Menu

#11 Dump drops time from DATE type with Oracle

open
nobody
None
5
2013-02-20
2008-11-04
No

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?

Discussion


Log in to post a comment.