[thelist] SQL Server datetime format

Scott Dexter sgd at ti3.com
Tue Nov 13 09:31:22 CST 2001

> I have a day, month, year, hour and minute and need to insert 
> it into a
> database field with the format datetime in SQL Server 2000. 

IIRC, it leans on the locale settings of the OS. You can find those
settings in the Control Panel in the Regional Options applet. 

That being said, SQL Server is pretty forgiving on how you specify the
date. Open up the SQL Books Online and type in "datetime data type,
formats" on the Index page. See also "SET DATEFORMAT" 

Are you getting errors?


More information about the thelist mailing list