Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have date format like this
9/10/2013
4-10-2014
this two format have in my data
can i load this data to script or do you what to modify data any one format before loading.
Hi,
In QV, you can load what ever you want so yes you can load your date like that with different format.
If you want, you can in your request SQL use : TO_DATE(UrDate,'format') like this TO_DATE(UrDate,''yyyy/mm/dd'')
or you can in your script use : Date(UrDate).
or you can still in your script modify this line : SET DateFormat='DD/MM/YYYY';
Regards,