Hi All,

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
How to do in sybase?

Thanks for your help!