Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi gurus,
LAST_UPDATE_DATE=01-01-2014 00:00:00 AM
i want lo load data >=LAST_UPDATE_DATE>=01-0102011 '00:00:00'.
its loading data for 2009,2010 ...2014.
its doing full load instead of delta
how to filter load when date as time stamp with Ante meridian,post meridian
thanks in advance
Hi,
Try with
Load *
From Source
Where
LAST_UPDATE_DATE >= '01-01-2011 00:00:00 AM' and LAST_UPDATE_DATE <= '01-01-2014 00:00:00 AM';
Regards
Anand
What is your source?
oracle
LAST_UPDATE_DATE>=To_date('01-01-2011 00:00:00','MM-DD-YYYY HH:MI:SS')