Revision history [back]

Assuming the name of the column is "datecolumn", you can use the TOCHAR function to transform it into the format of month/day/year.

The syntax would look like this:

SELECT TOCHAR(datecolumn, 'MM/DD/YYYY') AS newdatecolumnname FROM tablename;

This will convert the datecolumn into the format of month/day/year and rename it to newdatecolumnname in the output.