If I want to test if a date/time is greater than 4am yesterday how would I go about doing it in sql?

check for anything greater than todays date Minus 20hrs

datediff maybe( not sure if that’s t-sql specific)? Do you need to consider timezones at all?

to_char(start_date, ‘YYYYMMDDHH24MISS’) > to_ char(sysdate-1,’YYYYMMDD’)||’040000′

works. I was sure I’d tried that before asking the question but must have had an error somewhere 🙂

easier:

your_date > DATEADD(hh, -20, CAST(CAST(GETDATE() AS DATE) AS DATETIME))

to_char(start_date, ‘YYYYMMDDHH24MISS’) > to_ char(sysdate-1,’YYYYMMDD’)||’040000′

Hang on, did you just call to_char on every record in the table? this is a one off right?

/not an SQL guy

No use for Oracle though 🙂

ah, scope creep… 😆

Would something like this work?

create_date >= TO_DATE(’28/01/2015 04:00:00.000000′,’MM/DD/YYYY HH24:MI:SS.FF’)

/still not an SQL, let alone an oracle, guy

create_date >= CURRENT_DATE – INTERVAL ‘1 DAY’ + INTERVAL ‘4 hours’