DEV Community

Cover image for Date Format In Mysql
dev laravel
dev laravel

Posted on

Date Format In Mysql

Mysql Query 1:

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?

Top comments (0)