SQL Server 2k

[infinitium]

Hi guys,

I'm wondering if there's a reference available for all data types in SQL Server 2k? I'm confused about the "datetime" data type... mm/dd/yyyy? or dd/mm/yyyy?

A URL reference (or MS KB) would be greatly appreciated

[westmich]

http://msdn.microsoft.com/library/de...da-db_7msw.asp
There are a couple of date/time data types, but for the most part they will work with any standard dates.

January 1, 2002
1-01-02
Jan-01-2002
1/01/02 12:00:00
etc...

[infinitium]

thanks!