I am exporting a database table to a flat file. When I currently export the database, the data in the date field is displaying some strange value(I.e. 11/2/1995, in the exported data yields 9436). Is the value Oracle's internal date format. How do I convert this date. Please help.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
oracle date conversion
- Thread starter impulse24
- Start date
Hi.
If you spool to a flat file (with spool command)
use the to_char - function to display in the format you need. (e.g.: select ... to_char(yourDate,'YYYY-MM-DD'),...)
If you use the export-tool (exp) the data should be read in by import-tool (imp) => no need to change the format.
Stefan
If you spool to a flat file (with spool command)
use the to_char - function to display in the format you need. (e.g.: select ... to_char(yourDate,'YYYY-MM-DD'),...)
If you use the export-tool (exp) the data should be read in by import-tool (imp) => no need to change the format.
Stefan
- Status
Similar threads
