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 |
|
cidmi.dovic
Yak Posting Veteran
53 Posts |
 Posted - 2009-03-24 : 08:10:13
|
| Hi,Recently I have migrated my db from a computer to another.In the first one the data format for the queries was 'yyyy-mm-dd' but in the new one it fails and I have to use 'yyyy-dd-mm'. It's a big deal for me beacause on my stored procedures I use the first format.Is this possible to change this parameter on the database?Thanks in advance.The Padrón peppers itch and other don't |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2009-03-24 : 10:43:01
|
| Your database would always have the yyyymmdd format. If your application needs a different format you just apply the formatting at client side.. there are tons of formatting options available. you should not change youd database design to accomodate the GUI format.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
cidmi.dovic
Yak Posting Veteran
53 Posts |
Posted - 2009-03-24 : 10:53:36
|
| That's what I want.To have the format in yyyymmdd not yyyyddmm as it has now.The Padrón peppers itch and other don't |
|
|
|
|
|
|
Datetime Format