Hi Mandeep

You can change the date format at SQL SERVER Level
USING SET DATEFORMAT <Format>
and at SQL Level/Query Level : Convert can be used

Regards

Banga Balvinder


-----Original Message-----
From: Mandeep Bhutani [mailto:[Email Address Removed] Wednesday, December 17, 2003 10:26 AM
To: LazyDBA.com Discussion
Subject: SQL Server Date format


Hi All,

How can I change the date format at the SQL Server
level???

Regards
Mandeep

__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/

---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page