Database Tutorials Mysql Tutorial

MySQL Date and Time

by Online Tutorials Library July 14, 2022

Literals: Date and Time

In MySQL programming, Date and Time literals are in the form of strings or numbers.

Following are some more formats in which date and time can be displayed.

EXAMPLE	FORMAT
‘2018-10-18’	‘YYYY-MM-DD’
‘20181018’	‘YYYYMMDD’
20181018	YYYYMMDD
’18-10-18′	‘YY-MM-DD’
181018	YYMMDD
‘2018-10-18 5:25:20’	‘YYYY-MM-DD HH:MM:SS’
‘2018101852520’	‘YYYYMMDDHHMMSS’
2018101852520	YYYYMMDDHHMMSS
’18-10-18 5:25:20′	‘YY-MM-DD HH:MM:SS’
‘18101852520’	‘YYMMDDHHMMSS’
18101852520	YYMMDDHHMMSS

Example 1

  select id, name, salary, date_format(sal_date,’%d-%m-%y’) as new_date_formate from staff1;  

MySQL Date and Time

Example 2

  select id, name, salary, date_format(sal_date,’%d%m%y’) as new_date_formate from staff1;  

MySQL Date and Time

Next TopicMySQL Procedure

cursor examples functions literals mysql mysql tutorial procedure programming regexp_instr()regexp_like()regexp_replace operator regular expression trigger

previous post

MariaDB vs MySQL

next post

MySQL IN Condition