Re: SQL Date Literal Syntax

2007-08-10 Thread Ian Skinner
Billy Cox wrote: If I understand the question properly, here is today's date in literal format: '2007-08-10' That is what I expected, but this failed. SELECT aField FROM aTable WHERE aDateTimeField = '2005-07-01' Apparently Oracle needs a DATE command in there. This is what worked SELECT

Re: SQL Date Literal Syntax

2007-08-10 Thread Ian Skinner
DATE '-mm-dd' I guess I can caulk this up to Oracle not my poor memory. I know in the other DBMS I have used - I did not have to use DATE. Thank You. ~| ColdFusion 8 - Build next generation apps today, with easy PDF and

RE: SQL Date Literal Syntax

2007-08-10 Thread Billy Cox
If I understand the question properly, here is today's date in literal format: '2007-08-10' -Original Message- From: Ian Skinner [mailto:[EMAIL PROTECTED] Sent: Friday, August 10, 2007 9:28 AM To: CF-Talk Subject: SQL Date Literal Syntax I think I'm getting old. I've been using