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 |
|
HenryFulmer
Posting Yak Master
110 Posts |
 Posted - 2011-11-17 : 16:06:00
|
| I need to reverse a column that has CHAR data in the form of 2009/10/17 in it.I need it to look as follows: 10/17/2009Any pointers would be appreciated. |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2011-11-17 : 16:22:30
|
| PRINT CONVERT(varchar(20), CAST('2009/10/17' as datetime), 101)?If you don't have the passion to help people, you have no passion |
 |
|
|
HenryFulmer
Posting Yak Master
110 Posts |
Posted - 2011-11-17 : 16:54:52
|
| Thank you! |
|
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2011-11-17 : 18:29:47
|
| as one famous person always says "wc"If you don't have the passion to help people, you have no passion |
|
|
|
|
|
|
[RESOLVED] reverse format