I need to select from a table and format the output like so (total is a SUM(value)):<BR><BR><pre class="ip-ubbcode-code-pre"> That's not what the SQL engine is for ...

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: ...