Wordpress - $wpdb->insert - MySQL NOW()

Question

is there any possibility to use the MySQL NOW() in the $wpdb->insert call?

When I use the following code, NOW() is not working.

$data = array(         'id' => NULL,         'order' => serialize($_POST['data']['Order']),         'created' => NOW(),         'user_id' => $current_user->ID     );  $wpdb->insert(ORDERS_TABLE, (array) $data ); 

Answer 1

I believe the canonical approach is to use the WordPress current_time() function passing it 'mysql' as the first parameter to specify a mysql timestamp compatible format (the alternative is UNIX timestamp format) and '1' as the second parameter to specify GMT time (default is local), like this:

$data = array(     'id' => NULL,     'order' => serialize($_POST['data']['Order']),     'created' => current_time('mysql', 1),     'user_id' => $current_user->ID );  $wpdb->insert(ORDERS_TABLE, $data); 

current_time('mysql', 1) outputs 2012-07-18 12:51:13.

More here: http://codex.wordpress.org/Function_Reference/current_time

Answer 2

For anyone using Wordpress 5.3 and above, the recommended approach is to now use wp_date, not current_time.

wp_date('Y-m-d H:i:s');