MySQL Forums
Forum List  »  MySQL for Excel

Date values do not get proper parenthesis when appending data
Posted by: Ries Spruit
Date: January 31, 2016 03:54PM


I am trying to append data to a table on a 5.5.28 MySQL server.

There is a timestamp and a date column in the table. I have two date column in Excel. The Append Data wizard recognises these columns as such and also recognises the columns in Excel als DateTime columns.

Unfortunately, the query that is generated upon execution contains a syntax error:

INSERT INTO `table` (`TimeStamp`,`Date`) VALUES ('2016-01-31 22:19:57',2016-01-01 00:00:00)

Strangely enough, the value that is going into the timestamp column is parenthesized correctly. The date value however does NOT get any parenthesis. This results in a syntax error.

I trust this may have something to do with my locale (nl-NL, Dutch). Our date format is dd-MM-yyyy, which often gives issues. However in this case the format is not the issue, but the missing parenthesis is.

Any advice is appreciated.

Options: ReplyQuote

Written By
Date values do not get proper parenthesis when appending data
January 31, 2016 03:54PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.