in reply to Formatting a date

you can also do
select UNIX_TIMESTAMP(timestamp_field) as timestamp_field ... execute query put timestamp_field into $timestamp_field print scalar(localtime($timestamp_field))
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.