Re: Using q() to define a query



2008/1/12 Dr.Ruud <rvtol+news@xxxxxxxxxxxx>:

"Carville, Stephen" schreef:

and c.certcrtdate >= to_date('%s','MM-DD-YYYY')

Aaargh, you should always use 'YYYY-MM-DD'.


Except when reality beckons.


--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist