Try
SELECT * FROM tblMainEntry,TblDetailEntry
WHERE tblMainEntry.EmpID = 60597
AND tblDetailEntry.REcordDate = TO_DATE('11-30-2001','MM-DD-');
assuming tblDetailEntry.REcordDate is a DATE field.
Regards,
Joel Parramore
-Original Message-
From: Angel
You need to use the to_date function...
For Inserting, use to_date on your variableto_date('#mydate#',
'DD-MON- HH:MI:SS AM')
And for selecting, you need to use a to_char on your field name...
Try this..
SELECT * FROM tblMainEntry,TblDetailEntry
WHERE
23-JAN-99
On Tue, 20 Nov 2001, Angel Stewart wrote:
How in the HECK do you enter dates into Oracle?
I have tried several variations of a simple date in SQL Plus, and
nothing seems to work. I keep getting an error saying Not a valid month.
This is with raw SQL, not going through CF.
doesn't Oracle have a to_date function or something like that? Maybe try
that.
23-JAN-99
On Tue, 20 Nov 2001, Angel Stewart wrote:
How in the HECK do you enter dates into Oracle?
I have tried several variations of a simple date in SQL Plus, and
nothing seems to work. I keep
Oracle (or is it SQL+ ?) has a parameter which
specifies the format for dates. If you have not reset
the default, it is '30-SEP-01'
--- Angel Stewart [EMAIL PROTECTED] wrote:
How in the HECK do you enter dates into Oracle?
I have tried several variations of a simple date in
SQL Plus, and
Safest method i found:
UPDATE ...DateCreated=
TO_DATE('#DateFormat(form.DateCreated,dd/mm/)#','DD/MM/')
SELECT ...WHERE trunc(DateCreated) =
TO_DATE('#DateFormat(variables.Startdate,dd/mm/)#','DD/MM/')
Pascal
PS: US citizens can use the mask DD-MM- if they like, but with
6 matches
Mail list logo