Home Forums SQL Server 2005 Working with Oracle SSIS Where Clause w/ Date Functions RE: SSIS Where Clause w/ Date Functions
robshobs
SSC Eights!
Points: 961
More actions
August 27, 2008 at 5:32 am
#863628
I finally figured it out. It was the lack of a format mask on the date conversion. I changed
to_date(LAST_UPDATED_DATE)
to
to_date(LAST_UPDATED_DATE, 'YYYY/MM/DD HH24:MI:SS)
and now the code works.
Rob