MySQL Workbench

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;

Example 2

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

Next TopicMySQL Procedure

← prev next →

Latest Courses

We provides tutorials and interview questions of all technology like java tutorial, android, java frameworks

Contact info

G-13, 2nd Floor, Sec-3, Noida, UP, 201301, India

[email protected].

Frontend

Data Analytics

Database

Online Compiler

Backend

Technical Interview

Java Interview

Web Interview

Database Interview

Company Interviews

MySQL Tutorial

MySQL Workbench

User Management

MySQL Database

Table & Views

MySQL Queries

MySQL Indexes

MySQL Clauses

MySQL Privileges

Control Flow Function

MySQL Conditions

MySQL Join

MySQL Key

MySQL Triggers

Aggregate Functions

MySQL Misc

MySQL Globalisation

Regular Expressions

FULLTEXT Search

Differences

Interview Questions

MySQL Date/Time Functions

MySQL Math Functions

MSQL String Functions