A strange problem of time format

here"s the thing:

the program prompts: Incorrect datetime value:""2018"-"05"-"23"11": "42": "53 "for column" time" at row 1

when inserting records into the database."

later, I copied the prompt "2018"-"05"-"23"11": "42": "53", and then manually inserted it into the database. After saving, the result "2018 "-" 05 "-" 23 "" 11 ":" 42 ":" 53 "automatically became" 0000-00-0000: 0000". Then I typed "2018"-"05"-"23"11": "42": "53"
and then I could insert it normally.

but there is no difference between "2018"-"05"-"23"11": "42": "53" in the error prompt and "2018"-"05"-"23"11": "42": "53" that I hit by hand. I compared two strings with svn, and they were really different, but I couldn"t see the difference. And ask the gods for advice. Thank you!

the following is the error time (the gods can copy it and insert it into the database for a try):
2018 "-" 05 "-" 23 "" 11 ":" 42 ":" 53

the following is the hand time:
2018-05-23 11:42:53

clipboard.png

Mar.13,2021

'2018-05-23 11:42:53'.split('').map(v => v.charCodeAt(0))

/*
[50, 48, 49, 56, 8206, 45, 8206, 48, 53, 8206, 45, 8206, 50, 51, 8206, 8206, 32, 8206, 49, 49, 8206, 58, 8206, 52, 50, 8206, 58, 8206, 53, 51]
*/

printed, mixed with strange things with a Unicode code point of 8206?

look up what is left to right symbol .


you can look it up like this:

   

MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1e45a3c-442d9.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1e45a3c-442d9.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?