10 Replies Latest reply: Aug 2, 2016 9:17 AM by swrana latha RSS

    Transferring a text value into date when loading in the data

    Marc van der Peet

      Dear all,

       

      I have got data that is structured like this:

       

      Date
      4-1-2016 18:13:23

       

      As I would like to have the value as DDMMYYYY I try to load the data like this:

       

          ODBC CONNECT32 TO [DWH_P3.world;DBQ=DWH_P3] (XUserId is BQYVFIBHWBMOTcAHbCTCEBdLTKREFLFJDKRGVOVD,   XPassword is dUbMAYVMQbcSWYIGTBSB);
          LOAD WEEK_IN,
           Date#(OFF_SWITCH_DAT, 'DD-MM-YYYY');

           SQL SELECT *

       

         FROM "LAB_SERVICES"."FBI_LKR_OFF_UITVAL";

       

      This however gives the following:

       

        Date
        42295

      So the date format seems wrong. Any thoughts on what goes wrong here?