This is not a straight perl answer but most Databases have a builtin date formatting commands. In Oracle you have the command TO_CHAR()used like this:

select colA, colB, to_char(date_column, 'Month DD, YYYY') from table;

This will convert the date into the name of the month along with the numeric day and a 4 digit year. OR

select colA, colB, to_char(date_column, 'HH24:MI:SS') from table;

This one gives you the hours in military fallowed by a colon then minutes then a colon then seconds.



--BigJoe

Learn patience, you must.
Young PerlMonk, craves Not these things.
Use the source Luke.