Unix time-stamp search Frondend users Module

The place to talk about things that are related to CMS Made simple, but don't fit anywhere else.
Post Reply
milagro
Forum Members
Forum Members
Posts: 41
Joined: Tue Mar 13, 2007 8:33 pm

Unix time-stamp search Frondend users Module

Post by milagro »

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

Code: Select all

SELECT FROM_UNIXTIME(data,'%d-%m')
FROM cms_module_feusers_properties
WHERE data LIKE '01-12';
Post Reply

Return to “The Lounge”