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 |
|
anupalavila
Yak Posting Veteran
56 Posts |
 Posted - 2008-09-29 : 01:24:24
|
| HaiHow can I save date value in database in the format Year-day-month. Now even though I insert the date value in dd/mm/yyyy and mm/dd/yyyy its saved as year-month-day ie 2008-09-29 00:00:00.000 how can I save it as 2008-29-09 00:00:00.000Thanks and Regards Anu Palavila |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-09-29 : 01:35:39
|
| sql server stores dates always in standard format yyyy-mm-dd hh:mm:ss.msmsmsyou shouldnt be worrying about how dates are stored in table. you can always retrieve it in format you want using CAST CONVERT functions. however if your requirement is only for displaying dates, you should be strongly considering to do this at your front end application which contains built-in functions for this. |
 |
|
|
|
|
|
save date in format year-month-day