oracle date conversion to SQL format

[dhiner]

Hi,
I'm currently trying to import information from an Oracle database for yesterday's date. The date format in Oracle is '1030301'. I am unclear on how to write my import procedure to import yesterday's date in SQL. Does anyone have any ideas how I could convert the date format so that SQL will import yesterday's date without having to change the criteria every day to import the information?

Thanks in advance,
David Hiner, DBA
MCI/NCI

 

[jamminjaymeyer]

Sounds like you are using an Aspect phone switch.

I had the same problem. Try this formula for a where clause:

where(DATE_STAMP='1' || to_char(sysdate-1,'yymmdd'))

This is what you can pass to oracle to get back all of yesterday's data.

This formula will not work for dates before 2000.

Hope this helps.

 

[dhiner]

Thanks jamminjaymeyer, works like a charm.

David