7 Replies Latest reply: May 25, 2012 7:15 AM by goodychurro1 RSS

    Timestamp in database for new row

    goodychurro1

      I have a timestamp field in my db.
      In my mysql program I clicked on the box that says "On Updated Current_Timestamp" which works fine for updating rows in the database and adds the time.
      Now I want it to add the time for NEW rows, so in the default box I put now();  but I get an sql error. I am doing it in the database to lessen the load on coldfusion but maybe something like this is better in my cfquery insert into sql?:

       

      <cfqueryparam cfsqltype="cf_sql_timestamp" value="#now()#" />

       

      What do you think I should do? Thanks