Thursday, 6 September 2012

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

SELECT * , DATE( FROM_UNIXTIME( `time_stamp` ) ) AS sBdat
FROM phpfox_feed
WHERE DATE( FROM_UNIXTIME( `time_stamp` ) ) = '2012-09-05'
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)