Hello.
How can I change (global) date format from yyyy-MM-dd to my custom format?
Thank you.For input or output?
I suggest you read below article. You find your answers in it:
http://www.karaszi.com/SQLServer/info_datetime.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"David Dvali" <david_dvali@.hotmail.com> wrote in message
news:u1gf6dBcFHA.2128@.TK2MSFTNGP15.phx.gbl...
> Hello.
> How can I change (global) date format from yyyy-MM-dd to my custom format?
> Thank you.
>|||I want change it globally for whole SQL Server?
"Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote in
message news:OtEYGgBcFHA.3280@.TK2MSFTNGP09.phx.gbl...
> For input or output?
> I suggest you read below article. You find your answers in it:
> http://www.karaszi.com/SQLServer/info_datetime.asp
> --
> Tibor Karaszi, SQL Server MVP
> http://www.karaszi.com/sqlserver/default.asp
> http://www.solidqualitylearning.com/
>
> "David Dvali" <david_dvali@.hotmail.com> wrote in message
> news:u1gf6dBcFHA.2128@.TK2MSFTNGP15.phx.gbl...
>|||That didn't answer my question. There no such thing as a global setting for
SQL Server datetime
format. You have to handle input in one way and output in another way. See m
y article, the first few
sections. It has all the answers and options.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"David Dvali" <david_dvali@.hotmail.com> wrote in message
news:%23v4GnkBcFHA.3400@.tk2msftngp13.phx.gbl...
>I want change it globally for whole SQL Server?
> "Tibor Karaszi" <tibor_please.no.email_karaszi@.hotmail.nomail.com> wrote i
n message
> news:OtEYGgBcFHA.3280@.TK2MSFTNGP09.phx.gbl...
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment