timestamp vs timestamp

Question

Post reply

timestamp vs timestamp

Kev Riley

SSCrazy Eights

Points: 9075
More actions
September 30, 2008 at 12:23 am

#191555

Comments posted to this topic are about the item timestamp vs timestamp

Viewing 7 posts - 1 through 6 (of 6 total)

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

StarNamer SSCrazy Eights Points: 8746 More actions · Answer 1

I notice that the ODBC datetime format is very strict!

select { ts '2008-09-21 12:34:56' }is OK.select { ts '2008-9-21 12:34:56' } produces a conversion error!

Derek

Kev Riley SSCrazy Eights Points: 9075 More actions · Answer 2

I guess thats a good thing in a cross-technology standard!

Kev

Jamie-2229 SSCrazy Eights Points: 8156 More actions · Answer 3

I wasn't aware of the ODBC datatype. Good question. Answer was obvious after the following worked:

DECLARE @ts timestamp, @dt as datetime

set @dt = {ts '2008-09-21 15:53:00'}

But, does the timestamp update from the code above? If not, how would this work?

Jamie

Chad Crawford SSChampion Points: 11610 More actions · Answer 4

Nicely written! Excellent job coming up with some answers that sound good if you haven't used a timestamp before, yet leaving the correct answer clearly on it's own.

Anipaul SSC-Insane Points: 24681 More actions · Answer 5

Anipaul

SSC-Insane

Points: 24681

October 1, 2008 at 1:07 am

#879331

Nice question.

kapil_kk SSC-Insane Points: 21316 More actions · Answer 6

really nice question 😀

_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/