I'm relatively new to Oracle Databases, and I've been stuck on an issue for the past few hours. The Oracle timestamp data type is capable of storing fractional seconds (up to 9 digits, 6 is default).

Does anyone know how to format the timestamp output from Oracle's PL/SQL into the default "date" output on Solaris? "date" defaults to "date +'%a %b %e %T %Z %Y'", as seen in the sample output below: ...