Re: Sysdate, help needed urgent:)

Kenny Liew wrote:
>
> 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')

-- 
Bo Lu
Senior Programmer/Analyst
Hospital and Clinical Informatics, U. of Utah
801-581-5964, bo.lu_at_hsc.utah.edu