I hope this is what you are seeking..
Set Dateformat dmy
Regards,
Usman
-----Messaggio originale-----
Da: ganesh kumar [mailto:[Email Address Removed] Wednesday, December 17, 2003 6:04 AM
A: LazyDBA.com Discussion
Oggetto: Re: SQL Server Date format
Hi
The following are the ways of doing it.
1) Set the SQLServer.RegionalSetting property to TRUE
and change the regional setting of ur sql server.
2) Use Convert() native sql function
Hope this helps.
Thanks
Ganesh.K
--- Mandeep Bhutani <[Email Address Removed] > 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] For additional commands, e-mail:
> mssqldba-[Email Address Removed]
________________________________________________________________________
Yahoo! India Mobile: Download the latest polyphonic ringtones.
Go to http://in.mobile.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] CONFIDENZIALE:
Questo messaggio ed i suoi allegati sono indirizzati esclusivamente
alle persone indicate in testa e possono contenere informazioni
confidenziali. Se avete ricevuto il messaggio per sbaglio, sappiate
che qualunque utilizzo improprio del contenuto è proibito, Vi
preghiamo quindi di inoltrarlo immediatamente al mittente e di
cancellare il messaggio. Per qualsiasi informazione vi inivitiamo a
contattarci scrivendo a [Email Address Removed]
Grazie
CONFIDENTIALITY NOTICE:
This message and its attachments are addressed solely to the persons
above and may contain confidential information. If you have received
the message in error, be informed that any use of the content hereof
is prohibited. Please return it immediately to the sender and delete
the message. Should you have any questions, please contact us by replying
to [Email Address Removed] you
--------------------------------------------------------------------
MS Sql Server LazyDBA home page