convert 'mm/dd/yyyy' to 'yyyy-mm-dd'
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 4
- Joined: Mon Nov 29, 2010 6:05 am
convert 'mm/dd/yyyy' to 'yyyy-mm-dd'
my input is '1/19/2011' i am reading as varchar. I need to convert it to '2010-01-19'
Re: convert 'mm/dd/yyyy' to 'yyyy-mm-dd'
define your input column as Date, length 10 bytes. Set date_format='%(m,s)/%(d,s)/%yyyy', so DS will convert it to the default format is "%yyyy-%mm-%dd.Shailendra_dstage wrote:my input is '1/19/2011' i am reading as varchar. I need to convert it to '2010-01-19'