Unix time-stamp search Frondend users Module
Posted: Wed Dec 01, 2010 8:10 am
Hello does anyone know how I can search the cms_module_feusers_properties table for a time-stamp?
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
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';