MySQL - Today Date

Generally, the date is represented using three values: date, month, and year. Dates have many possible variations, all of which depend on several inconsistency factors.

• DD/MM/YYYY, For instance - 04/04/2024

• YYYY/MM/DD, For instance - 2024/04/27

• DD-MM-YYYY, For instance - 04-04-2024

MySQL Today's Date

We have several built-in functions to retrieve and manipulate the MySQL today's date. The following are the functions: CURDATE(), CURRENT_DATE(), CURRENT_DATE.

CURDATE(): This function returns the current date as ‘YYYY-MM-DD’ (string) or ‘YYYYMMDD’ (numeric).

CURRENT_DATE(): This function is s synonym to the CURDATE() function which returns the current date in the same format.

CURRENT_DATE: This is also synonym of CURDATE() function.

MySQL CURDATE() Function

In the following example, we are retrieving the current date value using the CURDATE() function −

SELECT CURDATE() AS Today;

Output

On executing the given query, the output is displayed as follows −

MySQL CURRENT_DATE() Function

Similarly, we can also display the current date value using the CURRENT_DATE() function.

SELECT CURRENT_DATE() AS Today;

Output

On executing the given query, the output is displayed as follows −

MySQL CURRENT_DATE Function

In this example, we use the CURRENT_DATE function to retrieve the current date local to a system.

SELECT CURRENT_DATE AS Today;

Output

On executing the given query, the output is displayed as follows −

Inserting Date Values in a Table

Following are the steps to insert date and time values in a table −

• First, we must create a table that accepts date and time values.

• Second, we must insert the data into the newly created table, which accepts date and time data types.

Example

Now, let us a create a table with the name ORDERS using the following query −

CREATE TABLE ORDERS (
   OID INT NOT NULL,
   DATE VARCHAR (20) NOT NULL,
   CUSTOMER_ID INT NOT NULL,
   AMOUNT DECIMAL (18, 2)
);

Here, we are inserting values into the above-created table using the INSERT INTO statement as shown below −

INSERT INTO ORDERS VALUES 
(102, CURDATE() + 1, 3, 3000.00),
(100, CURDATE() - 5, 3, 1500.00),
(101, CURRENT_DATE() - 2, 2, 1560.00),
(103, CURRENT_DATE + 3, 4, 2060.00);

The table is created as follows −

Today Date Using Client Program

We can also perform Today Date Using Client Program.

Syntax

$sql = "SELECT CURRENT_DATE AS TODAYS_DATE";
$mysqli->query($sql);

sql = "SELECT CURDATE() AS TODAY_DATE";
con.query(sql)

String curr_date = "SELECT CURDATE() AS TODAYS_DATE";
statement.executeQuery(curr_date);

today_date_query = "SELECT CURDATE() AS Today"
cursorObj.execute(today_date_query)

Example

Following are the programs −

$dbhost = 'localhost';
$dbuser = 'root';
$dbpass = 'password';
$db = 'TUTORIALS';
$mysqli = new mysqli($dbhost, $dbuser, $dbpass, $db);
if ($mysqli->connect_errno) {
    printf("Connect failed: %s
", $mysqli->connect_error);
    exit();
}
//printf('Connected successfully.
');
$sql = "SELECT CURRENT_DATE AS TODAYS_DATE";
If($result = $mysqli->query($sql)){
    printf("Select query executed successfully...!\n");
    while($row = mysqli_fetch_array($result)){
        printf("Todays date: %s", $row["TODAYS_DATE"]);
    }
}
if($mysqli->error){
    printf("Error message: ", $mysqli->error);
}
$mysqli->close();

Select query executed successfully...!
Todays date: 2023-08-04   

var mysql = require('mysql2');
var con = mysql.createConnection({
    host: "localhost",
    user: "root",
    password: "Password"
});

  //Connecting to MySQL
  con.connect(function (err) {
  if (err) throw err;
  console.log("Connected!");
  console.log("--------------------------");

  sql = "CREATE DATABASE TUTORIALS;"
  con.query(sql);

  sql = "USE TUTORIALS;"
  con.query(sql);

  sql = "SELECT CURDATE() AS TODAY_DATE";
  con.query(sql, function(err, result){
    if (err) throw err
    console.log(result);
  });
});

[ { TODAY_DATE: 2023-08-14T18:30:00.000Z } ] 

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
public class TodayDate {
  public static void main(String[] args) {
    String url = "jdbc:mysql://localhost:3306/TUTORIALS";
    String user = "root";
    String password = "password";
    ResultSet rs;
    try {
      Class.forName("com.mysql.cj.jdbc.Driver");
            Connection con = DriverManager.getConnection(url, user, password);
            Statement st = con.createStatement();
            //System.out.println("Database connected successfully...!");
            //find current date using CURDATE() function
            String curr_date = "SELECT CURDATE() AS TODAYS_DATE";
            rs = st.executeQuery(curr_date);
            System.out.println("Today's date(using CURDATE() function): ");
            while(rs.next()) {
              String date = rs.getString("TODAYS_DATE");
              System.out.println(date);
            }
            //find today's date using CURRENT_DATE() function
            String sql1 = "SELECT CURRENT_DATE() AS TODAY_DATE";
            rs = st.executeQuery(sql1);
            System.out.println("Today's date(using CURRENT_DATE() function): ");
            while(rs.next()) {
              String dt = rs.getString("TODAY_DATE");
              System.out.println(dt);
            }
    }catch(Exception e) {
      e.printStackTrace();
    }
  }
}  

Today's date(using CURDATE() function): 
2023-08-14
Today's date(using CURRENT_DATE() function): 
2023-08-14

import mysql.connector
# Establishing the connection
connection = mysql.connector.connect(
    host='localhost',
    user='root',
    password='password',
    database='tut'
)
# Creating a cursor object
cursorObj = connection.cursor()
# displaying today date
today_date_query = "SELECT CURDATE() AS Today;"
cursorObj.execute(today_date_query)
# Fetching and printing the results
today_date_result = cursorObj.fetchone()
print("Today's Date:")
print(today_date_result[0])
# Closing the cursor and connection
cursorObj.close()
connection.close()  

Today's Date:
2023-08-07