Csv import is ignoring national setting for date columns

[expired user #8405]'s profile image [expired user #8405] posted 7 years ago in General Permalink

Hello,

if i import data from a csv there is an option to use a national format. But this only works with numbers. Is there a chance to use it with dates?

Regards Martin

ansgar's profile image ansgar posted 7 years ago Permalink

Not with HeidiSQL.

I would always use CSV files with some ISO date format, to minimize the points of failure.

Please login to leave a reply, or register at first.