How to retrieve only the date from a Column that the Datatype is TIMESTAMP

Question

I have a column in my database which the datetype is TimeStamp, but I want the only date part of this column not date and time, for example if the time stamp is (2016-02-06 21:01:27) so I only want the (2016-02-06), So I need your help

Possible duplicate of [Convert timestamp to date in MySQL query](http://stackoverflow.com/questions/9251561/convert-timestamp-to-date-in-mysql-query) — Giorgos Betsos, Feb 06 '16 at 22:01

score 1 · Accepted Answer · answered Feb 06 '16 at 22:03

1

you can use date() function

mysql> SELECT DATE('2003-12-31 01:02:03');
        -> '2003-12-31'

answered Feb 06 '16 at 22:03

Nir Levy

12,750
3
21
38

Thanks a lot @Nir Levy – MAO Feb 06 '16 at 22:09

How to retrieve only the date from a Column that the Datatype is TIMESTAMP

1 Answers1