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)

🌚 Friends don't let friends browse without dark mode.

Sorry, it's true.