SQL server 2000 datetime type?

[markshen2004]

what is the format for datetime type in SQL Server 2000?

mm/dd/yy or dd/mm/yy

May I control the format? Thanks

Mark

 

[jmk418]

hi mark
the standard format is yyyy-mm-dd
you can change it using the covert function
convert(<data type>(length),<date>,style)
style 101 is dd/mm/yyyy

 

[markshen2004]

please give me a examole for.

convert(<data type>(length),<date>,style)

Thanks

 

[ESquared]

markshen2004,

Do you have SQL Server Books Online installed with Enterprise Manager? All the help you need should be in there.

Also, if you want your whole database to operate with a different format, you might look into the SET DATEFORMAT option.

SET DATEFORMAT mdy
SET DATEFORMAT dmy

 

[markshen2004]

I do not have SQL Server Books Online .Please let me know if I can view it online but I need the URL.thank

 

[ESquared]

BO comes with the installation of SQL server, so you should have a copy lying around somewhere. As for online... try searching the microsoft site.

Like... a Google search
site:microsoft.com sql server books online

 

[jmk418]

convert(varchar(10),getdate(),101)

 

[SQLBill]

Mark,

BOL is installed as part of the Client Tools. You can find it at Start>Programs>Microsoft SQL Server>Books OnLine.

-SQLBill

 

[SQLSister]

YOu can also click on help in ENterprise Manager

Questions about posting. See faq183-874

 

[Nuovo2004]

Actually, help in enterprise manager only points to the microsoft management console help file.
Query Analyzer has an excellent transact SQL reference. Lookup Cast and Convert and they have a whole section on date format manipulation.

 

[ESquared]

When I hit F1 in Enterprise Manager, SQL Server Books Online comes up.

 

[markshen2004]

I get a message "help topic not found" when I press F1

 

[ESquared]

download and install it