Khóa học miễn phí MySQL – Today Date nhận dự án làm có lương

MySQL – Today Date

Table of content


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

Khóa học lập trình tại Toidayhoc vừa học vừa làm dự án vừa nhận lương: Khóa học lập trình nhận lương tại trung tâm Toidayhoc