HomeForum
Welcome, Guest

Problem with loading DATE and TIMESTAMP columns.
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: Problem with loading DATE and TIMESTAMP columns.

Problem with loading DATE and TIMESTAMP columns. 1 year, 1 month ago #2352

  • Tanya
  • OFFLINE
  • Fresh Boarder
  • Posts: 2
  • Karma: 0
Dear Madame/Sir,

I downloaded your trial version, trying to find software, which import data into Oracle database.
I found the problem with loading DATE and TIMESTAMP columns.
The DATE column – it cannot convert string “MM/DD/YYYY” to date.
The TIMESTAMP column – it cut data “MM/DD/YYYY HH:MI:SS” into two separate columns – “MM/DD/YYYY” and
“HH:MI:SS”.

Any suggestions ?
Thank you in advance.

Tanya

Re: Problem with loading DATE and TIMESTAMP columns. 1 year, 1 month ago #2353

  • Tanya
  • OFFLINE
  • Fresh Boarder
  • Posts: 2
  • Karma: 0
You are using wrong date format

Use NN instead of MI

Mike
  • Page:
  • 1
Time to create page: 0.15 seconds

Testimonials

I want to say your tool has assisted us greatly in launching a large program for a new client. You were very responsive in making changes to accommodate some of our unique needs. Thanks!!

User Login

You only need to log in or register to use our support forum



Our customers

BP

BBC

HSBC


Databases we work with

Go to top