1 Reply Latest reply: Oct 17, 2014 4:02 AM by Erwan Morin RSS

    date tables

    Suresh Babu

      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

          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,