The Darshak

How to convert timestamp to date in MYSQL?

—

by

darshakkumar
in

MYSQL:

SELECT DATE( FROM_UNIXTIME( `time_stamp` ) ) AS sBdat FROM users

 

OUTPUT:

2012-09-06

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *