Hi Kevin! On 01/10/2008 11:25 AM Kevin Waterson wrote: > This one time, at band camp, Tobias Schlitt <[EMAIL PROTECTED]> wrote: > >>>>> I set up a db with a timestamp column (since DatabaseSchema supports it) >>>>> and wanted to use it in PO with the new date converter. Unfortunately for >>>>> me the converter accepts only time values as integer timestamps, but >>>>> MySQL returns strings like '2008-01-08 10:14:08'.
> why not just SELECT UNIX_TIMESTAMP(your_timestamp_col) AS epoch_time FROM > your_table This would be a solution to convert the internal MySQL representation to a Unix timestamp. However, you would need to manually adjust the query to achieve this and could not do this automatically in PersistentObject. Regards, Toby -- Mit freundlichen Grüßen / Med vennlig hilsen / With kind regards Tobias Schlitt (GPG: 0xC462BC14) eZ Components Developer [EMAIL PROTECTED] | eZ Systems AS | ez.no -- Components mailing list [email protected] http://lists.ez.no/mailman/listinfo/components
