Sponsored Links
Convert date with timezone to Oracle time
How to Convert date with timezone to Oracle time?
have a csv text file with one of the date column ex: 2010-05-23T09:15:46-07:00
do not know which date format is this and I am trying to load the data file into a Oracle (10.2.0.4 version) table and giving error for date column.
using Toad (9.7.2.5) for loading the data(Import Table data utility) from file.
Answer:
note, DATE columns do not have timezone information.
So what date would you expect to be stored for 2010-05-23T09:15:46-07:00
if you want timezone info, you will need to use TIMESTAMP WITH TIME ZONE type columns
Page 1
|
| 
