HomeForum
Welcome, Guest

import data from txt to mysql time field
(1 viewing) (1) Guest
  • Page:
  • 1

TOPIC: import data from txt to mysql time field

import data from txt to mysql time field 8 months, 2 weeks ago #3727

  • Marek
  • OFFLINE
  • Fresh Boarder
  • Posts: 10
  • Karma: 0
Hello,

I want to import data from txt to mysql. I have time column in mysql and
when I want to import 00:00:00 from txt into time column in mysql database I
have a error that I can't import null into. Please help me. What type of
format of time shoult I type? %h:%m:%s?

Pelase help me asap.
See attachement.

Regards
Marek
Attachments:

Re: import data from txt to mysql time field 8 months, 2 weeks ago #3728

  • admin
  • OFFLINE
  • Moderator
  • Posts: 2191
  • Karma: 12
Please use HH:MM:SS format and make sure that you are using the latest version

7.7.7.21

Fixed bugs related to working with time fields in MySQL
Export into excel via DDE was introduced

Mike

Re: import data from txt to mysql time field 8 months, 2 weeks ago #3733

  • Marek
  • OFFLINE
  • Fresh Boarder
  • Posts: 10
  • Karma: 0
It works when you mapped as HH:NN:SS not HH:MM:SS.

Rgs.
  • Page:
  • 1
Time to create page: 0.20 seconds

Testimonials

"DBSL software is important part of core business processes and has enabled us to scale up our capacity."

Tim Matter
CRM Team manager,

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