[NTLUG:Discuss] OT Oracle date question on UNIX with OCI

[Fred James]

All
UNIX is the only forgiving factor - otherwise this is OT, but I should 
appreciate any help you may be able to offer

select date ..... and then pass it to an external procedure (OCI) ... 
but in the end I need to print the date and time as "mm/dd/yyyy 
HH:MM:SS" ... right now all I can get is "DD-MON-YY"
Regards
Fred James

Database: Oracle 8.0.4.1