Date Prob

In Sa the date format is dd/mm/yy. in sql server the format the format
is mm/dd/yy.
What code can be used to chnge the format to the SA date format
eithout chnging sql servers regional settings?Input or output?
This is a bigger question than what it might seem, so I suggest you start by reading up on the
basics, and you can then qualify the question: http://www.karaszi.com/SQLServer/info_datetime.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"amatuer" <njoosub@.gmail.com> wrote in message
news:1147097192.284336.19140@.y43g2000cwc.googlegroups.com...
> In Sa the date format is dd/mm/yy. in sql server the format the format
> is mm/dd/yy.
> What code can be used to chnge the format to the SA date format
> eithout chnging sql servers regional settings?
>|||Does SET DATEFORMAT give you what you want?
--
Keith Kratochvil
"amatuer" <njoosub@.gmail.com> wrote in message
news:1147097192.284336.19140@.y43g2000cwc.googlegroups.com...
> In Sa the date format is dd/mm/yy. in sql server the format the format
> is mm/dd/yy.
> What code can be used to chnge the format to the SA date format
> eithout chnging sql servers regional settings?
>