Re: Sysdate, help needed urgent:)

>> Anyone out there knows how can I pull rows out from a table using an SQL
>> statement, where the date in the rows equals the current date?
>
>select * from test where to_char(test_col, 'mm/dd/yy')
>=to_char(sysdate, 'mm/dd/yy')
>
>--
Or this:
select * from test where trunc(test_col)=trunc(sysdate);

This is needed due to the records after noon begin rounded up and those before noon being rounded down.

-- 
=========================================================
            http://www.li.net/~gsa/index.html
This is my signature file, not part of this mail message.