2 Replies Latest reply: May 30, 2017 4:34 AM by Marcus Sommer RSS

    How load Datetime Column from SQL?

    Marian Lomencik

      SQL column Datum is DateTime Type, but Time part is 00:00:000.

      I tested 3 metods conversion column Datum.

       

      In QVD, DatumSQL convert to Date (32bit integer), another two to 32bit Integer + String. I need show DatumStr format on sheets.

      But what about size QVD and Set Analysis?

       

      Which date format I should use in LOAD Script?