Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
sakamsureshbabu
Creator
Creator

date tables

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. 

Labels (1)
1 Reply
Not applicable

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,