The Darshak

How to convert timestamp to date in MYSQL with where clause?

—

by

darshakkumar
in
SELECT * , DATE( FROM_UNIXTIME( `time_stamp` ) ) AS sBdat
FROM phpfox_feed
WHERE DATE( FROM_UNIXTIME( `time_stamp` ) ) = ‘2012-09-05’

Comments

Leave a Reply

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