in reply to Formatting a date
This way everything that deals with seconds since epoch will work on the data you get out of your database. Not exactly the format you wanted but getting to that format should be pretty straight forward once you have time in a more standard format.select UNIX_TIMESTAMP(timestamp_field) as timestamp_field ... execute query put timestamp_field into $timestamp_field print scalar(localtime($timestamp_field))
|
|---|