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 1

snippet

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

snippet

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

Related Tutorial

1 MySQL Comments

2 MySQL Cursor

3 MySQL Functions

4 Literals (Constants)

5 Literals: Date and Time

6 MySQL Procedure

7 MySQL Trigger

Try it

Contents +