What I am trying to do is insert the to_date('#DateFormat(fromtimestamp1, "DD-mmm-YYYY")#' || ' ' || '#TimeFormat(fromtimestamp1, "HH:mm:ss")#','DD-MON-YYYY HH24:MI:SS')
value into MS Access and I am not sure how to treat your explanation using cfqueryparam cfsqltype="cf_sql_timestamp" value="#fromtimestamp1#"
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>
Jim Watkins
----- Original Message -----
From: Jochem van Dieten
To: CF-Talk
Sent: Wednesday, December 31, 2003 9:35 AM
Subject: Re: to_date and MS Access
Jim Watkins said:
> I need to convert the following Oracle SQL to MS Access How would I
> do that? I realize in MS Access use #01/10/99# and in Oracle use
> To_Date('01/10/99') but putting in the additional #'s confuse me
> (and ColdFusion server both)
>
> to_date('#DateFormat(fromtimestamp1, "DD-mmm-YYYY")#' || ' ' ||
> '#TimeFormat(fromtimestamp1, "HH:mm:ss")#','DD-MON-YYYY HH24:MI:SS')
<cfqueryparam cfsqltype="cf_sql_timestamp" value="#fromtimestamp1#">
Oracle is supposed to understand this too ...
Jochem
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
