I need to convert mmddyy format to mm/dd/yyyy
071007 -->7/10/2007
I tried stringtodate(date,'%mm%dd%%yy)-->out result is 7/10/1907 but i need 7/10/2007
Thanks in advance.
Raj
Date Conversion
Moderators: chulett, rschirm, roy
Re: Date Conversion
The default representation from year in yy to yyyy format happens in that way(taking 1900 as base year). You need to give 2007 as input instead of 07 ... that can be done using string manipulations.
It took me fifteen years to discover I had no talent for ETL, but I couldn't give it up because by that time I was too famous.
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA