Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have a data in which the date format is as below:
1-JAN_2013
2-JAN_2013 and so on...
How can i change it in standard format as the Year(), Month() commands are not working on the mentioned format.
Thanx in Advance
try this
load*,
year(Date) as Year,
Month(Date) as Month;
load
Date(Date#(Purgechar(Datefield,'_,-'),'DDMMMYYYY'),'DD-MMM-YYYY') as Date
FieldA,Fieldb,
....
..so on
from table;