Posted: Tue Jul 10, 2007 1:24 pm
Hi DSguru2B,
The date got added by one.
Ex: 07-01-2007 00:00:00 (In SQL tool)
07-02-2007 00:00:00 (In DS)
Not understanding what's going on
.... As suggested by Craig I will ask my lead to check with the offical support provider...
The date got added by one.
Ex: 07-01-2007 00:00:00 (In SQL tool)
07-02-2007 00:00:00 (In DS)
Not understanding what's going on
.... As suggested by Craig I will ask my lead to check with the offical support provider...DSguru2B wrote:Strange and beats me.
Try providing TRUNC(Field_date) in the derivation column in the column's tab. Do you still get the date with 1 added to it. Or this time you are getting the correct date. Time will be 00:00:00 as you are truncating the time part. This is just for debugging purposes.