This discussion is archived
4 Replies Latest reply: Jan 9, 2013 10:26 AM by tparvaiz RSS

uploading data - issues with date conversion

tparvaiz Newbie
Currently Being Moderated
Hi,

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

Thanks

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points