datetime stored as integer, please help!

Question

datetime stored as integer, please help!

Viewing 4 posts - 16 through 18 (of 18 total)

You must be logged in to reply to this topic. Login to reply

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 1

Then I stand corrected.

But that doesn't seem to be obvious though.. The dateadd function in particular, what variation is there to adding (or deleting) time that would be configured by the server? Some of the other date functions maybe, but not this one.. Am I missing something, or did they just mark it non-deterministic.

CEWII

GSquared SSC Guru Points: 260824 More actions · Answer 2

DateAdd month, if you're using the Arabic calendar or Chinese calendar, functions quite differently than if you're using the Gregorian calendar. All by itself, that makes the function non-deterministic.

Edit: Hebrew calendar would be different too.

- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Elliott Whitlow SSC Guru Points: 102402 More actions · Answer 3

Sorry, I was completely forgetting about the other calendaring methods. Ah, American thinking.. Gotta love it..

CEWII

devilsid SSC Eights! Points: 830 More actions · Answer 4

Just a note when working with datetime stored as number/int...

check if it is stored in seconds or milliseconds .. i.e if it is 10 characters or 13 characters...

code to convert if seconds

select dateadd(hour,-1,(dateadd(second,([your columnname]),'1/1/1970')))

from [your table name]

if milliseconds

select dateadd(hour,-1,(dateadd(second,([your columnname]/1000),'1/1/1970')))

from [your table name]

hope this helps.

Cheers 😀