hi all,
i want to pull all the events that occurred from
(today - 2 hours) forward (all events during todays
current date and the last 2 hours from yesterday).
i tried to hack together some mailing list information
to this application and came up with this...
WHERE t_inspect.inspect_timestamp::date >
(current_date::timestamp - 720 'sec'::interval)
inspect_timestamp is datatype timestamp. i probably
shouldn't cast it to date, now that i think about
it... but i bet that won't make the query run right
all by itself.
i'm here so you can bet it didn't work. ;-)
any help w/b much appreciated.
tia...
____________________________________________________
Start your day with Yahoo! - make it your home page
http://www.yahoo.com/r/hs