- MySQL Basics
- MySQL - Home
- MySQL - Introduction
- MySQL - Features
- MySQL - Versions
- MySQL - Variables
- MySQL - Installation
- MySQL - Administration
- MySQL - PHP Syntax
- MySQL - Node.js Syntax
- MySQL - Java Syntax
- MySQL - Python Syntax
- MySQL - Connection
- MySQL - Workbench
- MySQL Databases
- MySQL - Create Database
- MySQL - Drop Database
- MySQL - Select Database
- MySQL - Show Database
- MySQL - Copy Database
- MySQL - Database Export
- MySQL - Database Import
- MySQL - Database Info
- MySQL Users
- MySQL - Create Users
- MySQL - Drop Users
- MySQL - Show Users
- MySQL - Change Password
- MySQL - Grant Privileges
- MySQL - Show Privileges
- MySQL - Revoke Privileges
- MySQL - Lock User Account
- MySQL - Unlock User Account
- MySQL Tables
- MySQL - Create Tables
- MySQL - Show Tables
- MySQL - Alter Tables
- MySQL - Rename Tables
- MySQL - Clone Tables
- MySQL - Truncate Tables
- MySQL - Temporary Tables
- MySQL - Repair Tables
- MySQL - Describe Tables
- MySQL - Add/Delete Columns
- MySQL - Show Columns
- MySQL - Rename Columns
- MySQL - Table Locking
- MySQL - Drop Tables
- MySQL - Derived Tables
- MySQL Queries
- MySQL - Queries
- MySQL - Constraints
- MySQL - Insert Query
- MySQL - Select Query
- MySQL - Update Query
- MySQL - Delete Query
- MySQL - Replace Query
- MySQL - Insert Ignore
- MySQL - Insert on Duplicate Key Update
- MySQL - Insert Into Select
- MySQL Indexes
- MySQL - Indexes
- MySQL - Create Index
- MySQL - Drop Index
- MySQL - Show Indexes
- MySQL - Unique Index
- MySQL - Clustered Index
- MySQL - Non-Clustered Index
- MySQL Operators and Clauses
- MySQL - Where Clause
- MySQL - Limit Clause
- MySQL - Distinct Clause
- MySQL - Order By Clause
- MySQL - Group By Clause
- MySQL - Having Clause
- MySQL - AND Operator
- MySQL - OR Operator
- MySQL - Like Operator
- MySQL - IN Operator
- MySQL - ANY Operator
- MySQL - EXISTS Operator
- MySQL - NOT Operator
- MySQL - NOT EQUAL Operator
- MySQL - IS NULL Operator
- MySQL - IS NOT NULL Operator
- MySQL - Between Operator
- MySQL - UNION Operator
- MySQL - UNION vs UNION ALL
- MySQL - MINUS Operator
- MySQL - INTERSECT Operator
- MySQL - INTERVAL Operator
- MySQL Joins
- MySQL - Using Joins
- MySQL - Inner Join
- MySQL - Left Join
- MySQL - Right Join
- MySQL - Cross Join
- MySQL - Full Join
- MySQL - Self Join
- MySQL - Delete Join
- MySQL - Update Join
- MySQL - Union vs Join
- MySQL Keys
- MySQL - Unique Key
- MySQL - Primary Key
- MySQL - Foreign Key
- MySQL - Composite Key
- MySQL - Alternate Key
- MySQL Triggers
- MySQL - Triggers
- MySQL - Create Trigger
- MySQL - Show Trigger
- MySQL - Drop Trigger
- MySQL - Before Insert Trigger
- MySQL - After Insert Trigger
- MySQL - Before Update Trigger
- MySQL - After Update Trigger
- MySQL - Before Delete Trigger
- MySQL - After Delete Trigger
- MySQL Data Types
- MySQL - Data Types
- MySQL - VARCHAR
- MySQL - BOOLEAN
- MySQL - ENUM
- MySQL - DECIMAL
- MySQL - INT
- MySQL - FLOAT
- MySQL - BIT
- MySQL - TINYINT
- MySQL - BLOB
- MySQL - SET
- MySQL Regular Expressions
- MySQL - Regular Expressions
- MySQL - RLIKE Operator
- MySQL - NOT LIKE Operator
- MySQL - NOT REGEXP Operator
- MySQL - regexp_instr() Function
- MySQL - regexp_like() Function
- MySQL - regexp_replace() Function
- MySQL - regexp_substr() Function
- MySQL Fulltext Search
- MySQL - Fulltext Search
- MySQL - Natural Language Fulltext Search
- MySQL - Boolean Fulltext Search
- MySQL - Query Expansion Fulltext Search
- MySQL - ngram Fulltext Parser
- MySQL Functions & Operators
- MySQL - Date and Time Functions
- MySQL - Arithmetic Operators
- MySQL - Numeric Functions
- MySQL - String Functions
- MySQL - Aggregate Functions
- MySQL Misc Concepts
- MySQL - NULL Values
- MySQL - Transactions
- MySQL - Using Sequences
- MySQL - Handling Duplicates
- MySQL - SQL Injection
- MySQL - SubQuery
- MySQL - Comments
- MySQL - Check Constraints
- MySQL - Storage Engines
- MySQL - Export Table into CSV File
- MySQL - Import CSV File into Database
- MySQL - UUID
- MySQL - Common Table Expressions
- MySQL - On Delete Cascade
- MySQL - Upsert
- MySQL - Horizontal Partitioning
- MySQL - Vertical Partitioning
- MySQL - Cursor
- MySQL - Stored Functions
- MySQL - Signal
- MySQL - Resignal
- MySQL - Character Set
- MySQL - Collation
- MySQL - Wildcards
- MySQL - Alias
- MySQL - ROLLUP
- MySQL - Today Date
- MySQL - Literals
- MySQL - Stored Procedure
- MySQL - Explain
- MySQL - JSON
- MySQL - Standard Deviation
- MySQL - Find Duplicate Records
- MySQL - Delete Duplicate Records
- MySQL - Select Random Records
- MySQL - Show Processlist
- MySQL - Change Column Type
- MySQL - Reset Auto-Increment
- MySQL - Coalesce() Function
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 −
Today |
---|
2023-04-27 |
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 −
Today |
---|
2023-04-27 |
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 −
Today |
---|
2023-04-27 |
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 −
OID | DATE | CUSTOMER_ID | AMOUNT |
---|---|---|---|
102 | 20231012 | 3 | 3000.00 |
100 | 20231006 | 3 | 1500.00 |
101 | 20231009 | 2 | 1560.00 |
103 | 20231014 | 4 | 2060.00 |
Today Date Using Client Program
We can also perform Today Date Using Client Program.
Syntax
To display today date through a PHP program use CURDATE() function, we need to execute the "SELECT" statement using the mysqli function query() as follows −
$sql = "SELECT CURRENT_DATE AS TODAYS_DATE"; $mysqli->query($sql);
To display today date through a JavaScript Program use CURDATE() function, we need to execute the "SELECT" statement using the query() function of mysql2 library as follows −
sql = "SELECT CURDATE() AS TODAY_DATE"; con.query(sql)
To display today date through a Java program use CURDATE() function, we need to execute the "SELECT" statement using the JDBC function executeQuery() as follows −
String curr_date = "SELECT CURDATE() AS TODAYS_DATE"; statement.executeQuery(curr_date);
To display today date through a Python program use CURDATE() function, we need to execute the "SELECT" statement using the execute() function of the MySQL Connector/Python as follows −
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();
Output
The output obtained is as shown below −
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); }); });
Output
The output obtained is as shown below −
[ { 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(); } } }
Output
The output obtained is as shown below −
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()
Output
The output obtained is as shown below −
Today's Date: 2023-08-07