Technical Support Forums

Free, outstanding support from WebAssist and your colleagues

› WebAssist Forums › Data Bridge › SecurityAssist › Inserting Current Date into MySql

Inserting Current Date into MySql

Thread began 4/05/2009 10:18 am by zuffster370186 | Last modified 4/06/2009 9:41 am by zuffster370186 | 2038 views | 1 replies

4/06/2009 9:41 amRay BorduinWebAssist

The easiest way is to set the field as a timestamp and set its default value to: CURRENT_TIMESTAMP.

This way the database will do it for you.

Another option is to use <?php echo(date('Y-m-d H:i:s')); ?> as the value for that column.

Did this help? Tips are appreciated...

Build websites with a little help from your friends

Your friends over here at WebAssist! These Dreamweaver extensions will assist you in building unlimited, custom websites.

Build websites from already-built web applications

These out-of-the-box solutions provide you proven, tested applications that can be up and running now. Build a store, a gallery, or a web-based email solution.