InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 07:46:13 GMT20http://www.sqlservercentral.com/Forums/Topic578092-1228-1.aspxreally nice question :-DThu, 13 Dec 2012 07:24:53 GMTkapil_kkhttp://www.sqlservercentral.com/Forums/Topic578092-1228-1.aspxNice question.Wed, 01 Oct 2008 01:07:34 GMTAnipaulhttp://www.sqlservercentral.com/Forums/Topic578092-1228-1.aspxNicely 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.Tue, 30 Sep 2008 09:27:15 GMT Chad Crawfordhttp://www.sqlservercentral.com/Forums/Topic578092-1228-1.aspxI wasn't aware of the ODBC datatype. Good question. Answer was obvious after the following worked:DECLARE @ts timestamp, @dt as datetimeset @dt = {ts '2008-09-21 15:53:00'}But, does the timestamp update from the code above? If not, how would this work?Tue, 30 Sep 2008 05:46:07 GMTJamie Longstreet-481950http://www.sqlservercentral.com/Forums/Topic578092-1228-1.aspxI guess thats a good thing in a cross-technology standard!KevTue, 30 Sep 2008 04:04:08 GMTkevrileyhttp://www.sqlservercentral.com/Forums/Topic578092-1228-1.aspxI notice that the ODBC datetime format is very strict![code]select { ts '2008-09-21 12:34:56' }[/code]is OK.[code]select { ts '2008-9-21 12:34:56' }[/code] produces a conversion error!Tue, 30 Sep 2008 03:11:10 GMTDerek Dongrayhttp://www.sqlservercentral.com/Forums/Topic578092-1228-1.aspxComments posted to this topic are about the item [B]<A HREF="/questions/T-SQL/64257/">timestamp vs timestamp</A>[/B]Tue, 30 Sep 2008 00:23:08 GMTkevriley