What are the differences between "now()" and "CURRENT_DATE()" in PHP when inserting timestamps into a database?

When inserting timestamps into a database in PHP, "now()" and "CURRENT_DATE()" are used to get the current date and time. The main difference between the two is that "now()" includes both the date and time, while "CURRENT_DATE()" only includes the date. Depending on the requirements of your database schema, you would choose one over the other. 

// Using "now()" to insert current date and time into a database
$query = "INSERT INTO table_name (timestamp_column) VALUES (now())";

// Using "CURRENT_DATE()" to insert current date into a database
$query = "INSERT INTO table_name (date_column) VALUES (CURRENT_DATE())";

Keywords

now() CURRENT_DATE() timestamps database differences

Related Questions