Monday, March 12, 2012

how can I let DATEFORMAT by default

SET DATEFORMAT change format of datetime in query
I need to let datetime format in YMD by default
How can I get it?
ThansThe language setting determines the default value for the DATEFORMAT. To
display the default setting for each language issue the following command:
sp_helplanguage
----
----
--
Need SQL Server Examples check out my website at
http://www.geocities.com/sqlserverexamples
"parodrig" <parodrig@.discussions.microsoft.com> wrote in message
news:A9A1C085-FB65-4380-A6FC-DCDB7B1529F8@.microsoft.com...
> SET DATEFORMAT change format of datetime in query
> I need to let datetime format in YMD by default
> How can I get it?
> Thans

No comments:

Post a Comment