Oracle (SQL) Database - selecting / extracting a date (number)
I've got an Oracle database I'm pulling data from. I run this query to get yesterdays data:
SQL select * from HFM_ERRORLOG where DTIMESTAMP>= 42166.0;
and get the following:
42166 is 11/06/2015; if I put '11/06/2015' in to excel and convert the format of the cell to Number then '42166' is the number I get. The number of days since 1900 I understand. I need to modify the above select command to use a variable for "yesterdays date" so I can automate it, instead of hard-coding the number in.