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
MS Sql Server LazyDBA home page