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 |
|
sital
Yak Posting Veteran
89 Posts |
 Posted - 2008-12-16 : 08:38:17
|
| How to display the date in the following format dd/mm/yyyy?I want to retrieve the order date column in the above format.Pls help..thanks in advance.... |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2008-12-16 : 08:43:11
|
| Do this in the front end, but if you still want to do it in SQL, look up CONVERT() in BOL. |
 |
|
|
JamesRyan
Starting Member
18 Posts |
|
|
sshelper
Posting Yak Master
216 Posts |
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
Posted - 2008-12-16 : 23:30:59
|
| SELECT CONVERT(VARCHAR(10), GETDATE(), 103) AS [DD/MM/YYYY] |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-16 : 23:32:52
|
| whats the front end tool you're using? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
|
|
|
|
|
Date format