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 |
|
micnie_2020
Posting Yak Master
232 Posts |
 Posted - 2011-11-25 : 03:19:18
|
| Hi All,Can i remain the type as date but format must be dd/mm/yyyySELECT CONVERT(VARCHAR(10), GETDATE(), 101)Please advise.Thank you.Regards,Micheale |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2011-11-25 : 04:06:08
|
The type Date has its own format.Your desired format for display has nothing to do with that and you should do it in your front end if possible.
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
|
|
|
Date format in Date Type