July 24th, 2000, 07:54 AM
i have a table that is having a TIMESTAMP and i wanna print DATE as a user readable format ...Like May 6,1999...
But if i print date in the use environment it is printing ...
wht should i do to print date in user readable format
i am using mysql and perl DBI to read this TIMESTAMP from mysql ...
Anybody please help me in printing TIMESTAMP
as user readable format using perl ?
July 24th, 2000, 01:55 PM
You can either use the system's date function when inserting the date ($date = `date` or you can divide up the TIMESTAMP into year/month/day/time and with the use of arrays and some imagination, get the date.