ETL and Data Integration tools - Modern ETL software for everyone

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

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

It works when you mapped as HH:NN:SS not HH:MM:SS.

Rgs.