4 Replies Latest reply: Jan 9, 2013 12:26 PM by tparvaiz RSS

    uploading data - issues with date conversion


      I've got a table that I've downloaded from an oracle database using SAS. it has a column with dates in the following format: 10/31/2012 11:00:00 AM

      when I upload the data (via SQL workshop -> utilities ->data workshop -> load data) by classifying my dates as varchar2, it works fine... but fails when I select my column type to be DATE.

      Please advice how to fix this issue