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
SEL
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 A
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 think I'm getting old. I've been using so long I
can apparently no longer remember how to properly pass a data literal in
a SQL statement.
I'm trying to run a query through SQL Plus to our Oracle DBMS to compare
to my CF template results. Obviously SQL Plus is not going to parse
tags. I
4 matches
Mail list logo