MySQL date & time function.

[Amaresh]

Hi,

I am new with PHP & MySQL.

The problem I am confused with is the MySQL date & time function.

I am really confused with these functions for their use & how to query the database in various ways?

[elldeegee]

Date and Time Functions

To know the list of date & time functions available in MySQL please go to this webpage.
http://dev.mysql.com/doc/refman/5.1/...functions.html
It will let you know & understand the various date & time functions their use & importance.

[Bhardwaj]

The default way to store a date in MySQL is with the type DATE
Format which is standard:

• YYYY-MM-DD
• Date Range: 1000-01-01 to 9999-12-31

To insert the current date into your table you can use MySQL's built-in function CURDATE() in your query. One is manual & second is using CURDATE()

<?php
//This assumes you have already created the 'dateplayground' table
//Connect to DB
$query_manual = "INSERT INTO dateplayground (dp_name, dp_date)
    VALUES ('DATE: Manual Date', '2020-2-14')";
$query_auto = "INSERT INTO dateplayground (dp_name, dp_date)
    VALUE ('DATE: Auto CURDATE()', CURDATE() )";

mysql_query($query_manual) or die(mysql_error());
mysql_query($query_auto) or die(mysql_error());
?>

For detail information please follow this tutorial: http://www.tizag.com/mysqlTutorial/mysql-date.php