Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am looking for inputs on one issue.
My date columns data in input file is having dates in both formats DD/MM/YYYY HH:MM:SS and DD/MM/YYYY HH:MM:SS.
I need to make changes in my script so that it will store the date only in DD/MM/YYYY format in QVD.
Thanks in advance!!
Rohit
Try Date Function.
Load *,
Date(Floor(DateField),'DD/MM/YYYY') as NewField
From XYZ;
Regards,
Kaushik Solanki