How to import date type from csv ?

"x","x","x","1.8.2008","x"

I thought I couuld copy generated insert sql (& add STRTODATE), but no it is snipped of.

?

OK, preferences - turn off snip off, but anyway it looks like it eats date directly.

I don't think HeidiSQL offers any feature for that, you'll possibly have to write a LOAD DATA statement yourself so you can compose a SET clause. There're some user comments that explain how to do so in the MySQL manual page.

OK, preferences - turn off snip off, but anyway it looks like it eats date directly.

Yeah. eats it directly, sometimes, but what comes out in db is totaly unpredictable. i.e. date you send in becomes date in database but not same date as you send in.

There, for example, you have two red marked fields.

First is type date time, heidi should warn about that, if cheched, the simplest way upon 'Import!' button click, bring up input dialog box where user input format thta fits into this func: STR_TO_DATE(yourdatefield, '%m/%d/%Y')

Second is type of timestamp, should be shown, but be default checked of & disabled.