On 2008-01-12 11:54:03 +0100, Dr.Ruud wrote:
> "Carville, Stephen" schreef:
>
> > and c.certcrtdate >= to_date('%s','MM-DD-YYYY')
>
> Aaargh, you should always use 'YYYY-MM-DD'.
While I prefer YYYY-MM-DD, too (and where is MM-DD-YYYY used, anyway?
Isn't that usually written as MM/DD/YYYY or MM.DD.YYYY?), it doesn't
make a difference here: The string is converted to a date type, and
then two date values are compared. That one of them was computed from a
string is irrelevant.
hp
--
_ | Peter J. Holzer | If I wanted to be "academically correct",
|_|_) | Sysadmin WSR | I'd be programming in Java.
| | | [EMAIL PROTECTED] | I don't, and I'm not.
__/ | http://www.hjp.at/ | -- Jesse Erlbaum on dbi-users
pgphbxA2pRKIv.pgp
Description: PGP signature
