to_date and MS Access

[Jim Watkins]

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')

Jim Watkins

---

[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

---