Get only the date in timestamp in mysql

Question

On my database under the t stamp columns I have the date for example  2013-11-26 01 24 34   From that same column I only want to get the date  2013-11-26   How can i do this  Thank You

User · Answer

You can convert that time in Unix timestamp by using

select UNIX_TIMESTAMP('2013-11-26 01:24:34')

then convert it in the readable format in whatever format you need

select from_unixtime(UNIX_TIMESTAMP('2013-11-26 01:24:34'),"%Y-%m-%d");

For in detail you can visit link

User · Answer

You can use date t stamp  to get only the date part from a timestamp   You can check the date   function in the docs     DATE expr       Extracts the date part of the date or datetime expression expr       mysql  SELECT DATE  2003-12-31 01 02 03              -   2003-12-31

User · Answer

date  new DateTime  row  your date        echo  date- gt format  Y-m-d

[mysql] Get only the date in timestamp in mysql

Examples related to mysql

Examples related to date