MichaelLee

Results 4 comments of MichaelLee

I reproduced this bug; firstly, I create table 'demo', ``` curl --location --request POST 'http://127.0.0.1:5440/sql' \ --header 'Content-Type: application/json' \ --data-raw '{ "query": "CREATE TABLE `demo2` (`name` string TAG,`name1` string...

1. A date. The supported range is '1000-01-01' to '9999-12-31'. MySQL displays [DATE](https://dev.mysql.com/doc/refman/8.0/en/datetime.html) values in 'YYYY-MM-DD' format.See:https://dev.mysql.com/doc/refman/8.0/en/date-and-time-type-syntax.html 2. But permits assignment of values to [DATE](https://dev.mysql.com/doc/refman/8.0/en/datetime.html) columns using either strings or...

> @MachaelLee > > > But permits assignment of values to [DATE](https://dev.mysql.com/doc/refman/8.0/en/datetime.html) columns using either strings or numbers > > For such conversion, I guess we already have an example...

Well, I will check this, and reponse later.