Jim Watkins
----- Original Message -----
From: Jochem van Dieten
To: CF-Talk
Sent: Wednesday, December 31, 2003 10:53 AM
Subject: Re: to_date and MS Access
Jim Watkins wrote:
>
> For Oracle SQL=My script is:
>
> <cfquery name="insertleave" datasource="banner">
> insert into leaverequest (fromdate1)
> VALUES (to_date('#DateFormat(fromtimestamp1, "DD-mmm-YYYY")#' || ' ' || '#TimeFormat(fromtimestamp1, "HH:mm:ss")#','DD-MON-YYYY HH24:MI:SS'))
> </cfquery>
For both Oracle and Access, use:
<cfquery name="insertleave" datasource="banner">
INSERT INTO leaverequest (fromdate1)
VALUES (<cfqueryparam cfsqltype="cf_sql_timestamp"
value="#fromtimestamp1#">)
</cfquery>
Jochem
--
I don't get it
immigrants don't work
and steal our jobs
- Loesje
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
