Show record data in the last 1 hour in sybase ASA11

Question

select * from Trx   
where 
RequestTimestamp BETWEEN DATE(NOW()) AND DATEADD(HOUR, -1, GETDATE())

I have this sql code from sybase ASA11, hoping to show data in last 1 hour, but it just shows today's record from 00:00:00.000 AM till now(). What is wrong with my script, so it can show all of record from 1 last hour to now(). Can somebody help me?

score 1 · Accepted Answer · answered Sep 14 '20 at 07:25

1

It looks like you want:

where requestTimestamp >= dateadd(hour, -1, getdate())

If you have requestTimestamp in the future, then an upper bound is also needed:

where requestTimestamp between dateadd(hour, -1, getdate()) and getdate();

answered Sep 14 '20 at 07:25

GMB

216,147
25
84
135

wait, you're not using now()? – ilham setiawan Sep 14 '20 at 07:26
@ilhamsetiawan: `now()` and `getdate()` are synonyms. – GMB Sep 14 '20 at 07:27
what's the difference "If you have requestTimestamp in the future" (the second line)? coz I just run the script and have the same result with the first line/code – ilham setiawan Sep 14 '20 at 07:37
@ilhamsetiawan: so it means you don't have `requestTimestamp`s that are greater than `getdate()`. – GMB Sep 14 '20 at 07:40
I'm gonna use for an Event that run every one hour, I guess I'm using the first line, right? – ilham setiawan Sep 14 '20 at 07:47

Show record data in the last 1 hour in sybase ASA11

1 Answers1