> 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]
