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

• StarNamer

  SSCrazy Eights

  Points: 8746

  More actions

  September 30, 2008 at 3:11 am

  #878722

  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

  September 30, 2008 at 4:04 am

  #878742

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

  Kev

• Jamie-2229

  SSCrazy Eights

  Points: 8156

  More actions

  September 30, 2008 at 5:46 am

  #878772

  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

  September 30, 2008 at 9:27 am

  #878932

  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

  October 1, 2008 at 1:07 am

  #879331

  Nice question.

• kapil_kk

  SSC-Insane

  Points: 21316

  More actions

  December 13, 2012 at 7:24 am

  #1568302

  really nice question

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