Mysql format date

DATE_FORMAT(date, format)
-- E.g.
SELECT DATE_FORMAT(dateField, '%m/%d/%Y') FROM TableName;
-- See https://www.mysqltutorial.org/mysql-date_format/ for available formats

Source: mysqltutorial.org

Mysql date format

-- Converts 'dd.mm.yyyy' to date	(my_date_col is VARCHAR)
SELECT STR_TO_DATE(my_date_col,'%d.%m.%Y') AS my_strdate FROM my_table;
-- Converts 'dd.mm.yyyy' to 'YYYY-MM-DD'
SELECT DATE_FORMAT(STR_TO_DATE(my_date_col,'%d.%m.%Y'), '%Y-%m-%d') AS my_strdate
	FROM my_table;

Source: tutorialspoint.com

Mysql pretty date format

DATE_FORMAT(NOW(),'%M %e, %Y @ %h:%i %p') 
#Format is 'June 10, 2014 @ 06:52 PM'

Date format mysql

DECLARE df VARCHAR(20);
DECLARE dt VARCHAR(20);

SET df = DATE_FORMAT(_Datefrom,'%Y-%m-%d 00:00:00'); 
SET dt = DATE_FORMAT(_DateTo,'%Y-%m-%d 23:59:59');

Similar codes

1 vote353 views1 answer
Sequence item 6 expected str instance bytes found mysql workbench
SQL
0 vote119 views1 answer
Postgresql select fast check no rows
SQL
0 vote132 views3 answers
Constraint sql
SQL
0 vote128 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
2 votes109 views2 answers
Oracle multiple insert
SQL
-1 vote121 views1 answer
Add bool column in sql
SQL
32 votes121 views6 answers
How to change column name in sql
SQL
36 votes102 views3 answers
Finding duplicate column values in table with sql
SQL
0 vote100 views1 answer
Update set with inner join oracle
SQL
2 votes124 views1 answer
Removing view
SQL