Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
codrgi
Starting Member
11 Posts |
 Posted - 2012-03-23 : 11:08:51
|
| how do i compare the difference of 2 different Epoch Timestamp times, and compare them to differences in hours? while also returning the result of the differences between the two times? |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-03-23 : 11:29:31
|
Please give us an example.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
codrgi
Starting Member
11 Posts |
Posted - 2012-03-23 : 11:39:38
|
| for example we have these 2 different timestamps-Epoch timestamp1: 1332516308 --being currenttimeEpoch timestamp2: 1335192846 --being currentime + a month |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2012-03-23 : 11:53:43
|
[code]select (1335192846 - 1332516308) / (60 * 60) as [Diff in hours][/code]
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
|
|
|
convert a time??