39
Date Format In Mysql
This is query like this type of date format “Y-m-d“
SELECT DATE_FORMAT("2022-01-08", "%Y");
Output:
"2022"
Mysql Query 2:
SELECT DATE_FORMAT("2022-01-08", "%Y %M %d");
Output:
"2022 January 08"
People Know this ?
–> What is format of date in MySQL?
–> How can get date in dd mm yyyy format in MySQL?
–> How do I change the date format in MySQL?
–> How do I change the date format in SQL?
–> What is T and Z in timestamp?
–> Is timestamp or datetime better?
–> What is date function SQL?
–> How do I insert date in mm/dd/yyyy format in SQL?
–> How many date formats are there?
–> How do you create a date table in SQL?
39