date tables

sakamsureshbabu — Fri, 17 Oct 2014 06:57:36 GMT

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.

Re: date tables

Fri, 17 Oct 2014 08:02:04 GMT

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,