Date interpretation for imported data

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.
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top