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 |
|
deadfish
Starting Member
38 Posts |
 Posted - 2002-11-20 : 01:42:11
|
| Is there any function / sample script for me to convert a date like 'AUG-2002' to '2002-08-01'???Thanks! |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2002-11-20 : 03:21:12
|
quote:
Is there any function / sample script for me to convert a date like 'AUG-2002' to '2002-08-01'???Thanks!
Something likeselect convert (datetime, '01 ' + replace('AUG-2002','-',' '),106) |
 |
|
|
|
|
|
date format conversion