DMXzone Database Updater PHP Support Product Page

Using NOW() for TIMESTAMP field

Asked 01 Apr 2016 12:36:00
1
has this question
01 Apr 2016 12:36:00 David Woolley posted:
I have 2 TIMESTAMP fields in my table: date_created & date_updated

My Insert form has a hidden field for date_created
date_updated does not require a hidden field as it is set in phpmyadmin as 'onUpdate CURRENT_TIMESTAMP'

I need to set the value of the date_created field to NOW() but not sure how to do that.
If you put value="NOW()" , the quotes have to be stripped before processing.
I could do this by recoding the old Dreamweaver Insert Record Server Behavior, but need some advice about how to achieve this with the DB Updater Action Builder using Server Connect.

Reply to this topic