I like to search the table for birthdays so if today is 12-01-2010 I like to display everyone how birthday is today 12 Dec.
But the the problem is the search query. The database value is 344473200 and todays date is displayed as 1291158000
Code: Select all
SELECT FROM_UNIXTIME(data,'%d-%m')
FROM cms_module_feusers_properties
WHERE data LIKE '01-12';