Has this issue been resolved? I'd like a timestamp MVA so that I can filter by a person's age.
UNIX_TIMESTAMP ??? ughh.. this thing is horrible. Only dates after 1970? Did nothing happen before 1970? There's a man here back in 1999 making a fairly good argument for UNIX_TIMESTAMP returning a signed rather than unsigned INT and getting flack from a lot of people who only consider dates to be file time stamps. http://lists.mysql.org/mysql/15585 So hey hum... it's not going to achieve what I wanted. I'm getting my hands dirty in the SQL again with nasty little things like... (((TO_DAYS(`models`.`dob`) * 86400) + TIME_TO_SEC(`models`.`dob`)) - (TO_DAYS("1970-01-01") * 86400)) AS `dob` nasty stuff but it's better than treating every date before 1970 as zero. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en -~----------~----~----~----~------~----~------~--~---
