08-23-10, 23:55 #1Registered User
- Join Date
- Aug 2010
Unanswered: how to query the daily record in sybase iq
I am new user for sybase iq.
Currently, I need to write a sql script to query the daily record from the sybase iq.
Previously I am using oracle:
select * from vas
where datetime between trunc(sysdate-1) and trunc(sysdate)-1/24
Thanks for your help!