mistektips
Programmer
I need to convert date which in this format (mm/dd/yyyy) to (yyyymmdd) format. Can someone suggest?
Thanks!
Thanks!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Convert Date Format
- Thread starter mistektips
- Start date
- Status
DotNetGnat
Programmer
try...
CONVERT(mydate, varchar(20),112)
-DNG
CONVERT(mydate, varchar(20),112)
-DNG
- Status
Similar threads
- Locked
- Question
- Locked
- Question