Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
pmccann1
Posting Yak Master
107 Posts |
 Posted - 2006-09-12 : 05:26:42
|
| how do i go about changing this the server was set up and the default is american date format i need it to be dd/mm/yy |
|
|
chiragkhabaria
Master Smack Fu Yak Hacker
1907 Posts |
Posted - 2006-09-12 : 05:28:37
|
| look for SET DATEFORMAT on book onlineChirag |
 |
|
|
pmccann1
Posting Yak Master
107 Posts |
Posted - 2006-09-12 : 05:36:03
|
| this does not change the sql server datem this just changes the format for a given query |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-09-12 : 05:45:45
|
| Try go to CONTROL PANEL and change DATE format settings there in REGIONAL options.Peter LarssonHelsingborg, Sweden |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-09-13 : 10:16:20
|
| Always use DateTime parameters. Also when sending date to table send it in YYYYMMDD format so that you dont need to worry about Date SettingsMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Sql server date Format