* Håkan Elmqvist > Is there any MySQL built in function to convert datetime types to > real numbers (float) i.e. seconds or days since a reference date? > I can't find any in the manual.
There are plenty of date and time manipulating functions available. Take a look at to_days() and unix_timestamp(), for instance: <URL: http://dev.mysql.com/doc/mysql/en/Date_and_time_functions.html > They both return integers, though. Multiply by 1.0 to get a float ;) -- Roger -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
