Help: time format issues

dz930810

My computer time Now = 1-4, 2017, 9:54:07 AM, I have an error inserting the database (the field is a time type). I seem to have changed the time with Super Rabbit. Is there any way? Format (Now, "yyyy-mm-dd hh: mm: ss") is the same as before

maggic

Just use Format (Now, "yyyy-mm-dd hh: mm: ss") to format it once. Such a program has good compatibility.

dz930810

date a
a = Format (Now, "yyyy-mm-dd hh: mm: ss")
Time after execution
2017-1-4 am 09:54:07
Error inserting database

hanhuoby

You can use a stupid method, first intercept the string, and then convert the string into a time insert in SQL

dz930810

date a
a = Format (Now, "yyyy-mm-dd hh: mm: ss")
Time after execution
2017-1-4 am 09:54:07
Error inserting database
Although the problem is solved, I don't quite understand yet.
I just changed the type of a to string type. Obviously, the data field is a time type, and I insert the character type.