Timestamp to VARCHAR

1 TO_CHAR ( timestamp-expression , format-string )