Setting Oracle Timestamp with Coldfusion

This is a pretty simple question, and I searched the previous qu开发者_Python百科estions but couldn't find an answer.

How do you insert or create a timestamp in Oracle using Coldfusion?

You can insert it like this:

<cfquery name="qTest">
  insert into myTable(myTimestampCol)
  values (<cfqueryparam cfsqltype="cf_sql_timestamp" value="#now()#" />)
</cfquery>

Hope that helps.

Use Oracle's built-in SYSDATE function.

<cfquery name="qTest">
  insert into myTable(myTimestampCol)
  values (SYSDATE)
</cfquery>

When possible, I prefer the built-in database function for stuff like this. It's based on the database server clock rather than the ColdFusion server clock. It also avoids the ever-so-small overhead of converting a string to a date and putting it in a bind variable.