Re: Dates Oracle 8i & ASP - Please Help

I think it needs to be TO_DATE(CDATES ,'DD-MM-YY') or TO_DATE(CDATES ,'DD-MON-YY'). Jimi wrote:

> Hi,
>
> I am trying to insert dates into Oracle 8i but with no luck, i keep getting
> errors!! Could somone help me out with the syntax?
>
> Sean
>
> strInsert = "INSERT INTO SCHEDULE ( COURSEID, VENUE, AVAIL, TRAINER,
> MAXSTUDENTS, CDATES, FTIME) VALUES ( "&(COURSEID)&", '"&(VENUE)&"',
> '"&(AVAIL)&"', '"&(TRAINER)&"', "&(MAXSTUDENTS)&", '"&(FTIME)&"',
> "&(TO_DATE(CDATES ,DD-MMM-YY))&" )"
Received on Tue Mar 20 2001 - 11:36:15 CST