Date interpretation for imported data

  • Thread starter Thread starter Andrew
  • Start date Start date
A

Andrew

Hello,

I'm importing data into a table from a text delimited
ascii file/s. One of the fields is a timestamp, in the
format of MM/DD/YYYY hh:mm:ss. However when the data is
imported, it is interpreted as DD/MM/YYYY .... Is there
anyway to make the database interpret the data
differently? Apparently changing the system settings to
the desired format will work, however this will only serve
to cause more problems on my system than it will fix.

Thank you.
 
When you import the data, you can set up an import specification where you can change the date format. On importing, look for the Advanced button and create the spec. This can then be saved and used again for the same file import

----- Andrew wrote: ----

Hello

I'm importing data into a table from a text delimited
ascii file/s. One of the fields is a timestamp, in the
format of MM/DD/YYYY hh:mm:ss. However when the data is
imported, it is interpreted as DD/MM/YYYY .... Is there
anyway to make the database interpret the data
differently? Apparently changing the system settings to
the desired format will work, however this will only serve
to cause more problems on my system than it will fix

Thank you
 
Back
Top