SQL query problem with date/time format -- sql server new users

JL
7/7/2006 3:10:06 PM

OK..I figured it out...use single quote not #in the string.

John

[quoted text, click to view]

JL
7/7/2006 3:12:31 PM

Hi Hugo,
Thanks for the very quick reply! I did figure out the single quote vs
# but your suggestion on formats is excellent and I will follow them.

Thanks again,
John

On Sat, 08 Jul 2006 00:08:14 +0200, Hugo Kornelis
[quoted text, click to view]

Arnie Rowland
7/7/2006 3:20:00 PM

A couple of good resources related to datetime issues for your 'toolbox' is:

http://www.karaszi.com/SQLServer/info_datetime.asp
http://omnibuzz-sql.blogspot.com/2006/06/date-functions-in-sql-server-faq.html

--
Arnie Rowland*
"To be successful, your heart must accompany your knowledge."

[quoted text, click to view]

JL
7/7/2006 3:43:47 PM

Hi Arnie,
Excellent refernces. Thank you very much!

John

On Fri, 7 Jul 2006 15:20:00 -0700, "Arnie Rowland" <arnie@1568.com>
[quoted text, click to view]

Hugo Kornelis
7/8/2006 12:08:14 AM

[quoted text, click to view]

Hi John,

First, SQL Server uses single quotes (') to delimit date and time
constants, not hash symbols (#) or double quotes (").

Second. to prevent misinterpretation of the string (for instance, the
date above can be interpreted as march 12 or december 3, depending on
locale settings), you should stick to these formats:

* 'yyyymmdd' - date only. Note: no punctuation is used at all, just a
character string of 8 numeric characters. Time will default to midnight.
* 'yyyy-mm-ddThh:mm:ss' - date and time. Note: the parts of the date are
seperated by dashes; the parts of the time are seperated by colons and
an uppercase T seperates date from time.
* 'yyyy-mm-ddThh:mm:ss.mmm' - date and time with millisecond precision.
Note that SQL Server rounds to the nearest 1/300th second!
* 'hh:mm:ss' or 'hh:mm:ss.ttt' - time only. Date defaults to 1/1/1900.

--

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server new users

sql server new users : SQL query problem with date/time format