Dump drops time from DATE type with Oracle

neurolabs / henplus

HenPlus is a SQL shell that can handle multiple sessions in parallel. The commandline interface with the usual history functions features TAB-completion for commands, tables and columns. Database connect via JDBC.

GNU General Public License v2.0

97 stars 51 forks source link

Dump drops time from DATE type with Oracle #14

Open tbk303 opened 13 years ago

tbk303 commented 13 years ago

I have a DB using Oracle's DATE type which contains times as well as dates (as of 9.2). If I dump a table, the column is listed as type DATE and only the date is shown; the time data is lost.

Is this able to be handled or just tough luck that Oracle couldn't play nice with the standard?

neurolabs commented 13 years ago

Submitted:

Scott Kullberg ( skullberg ) - 2008-11-04 13:14:38 UTC