Golang：如何验证MySQL时间戳字符串

Question

How can we check that a string considered to be a MySQL TIMESTAMP is actually valid? The format used is:

YYYY-MM-DD HH:MM:SS[.fraction] where "fraction" has 3 digits.

For example 2016-03-28 12:17:30.022 should be valid. Preferably I would like to avoid regex and use time.Parse() but any other suggestion is welcome.

Answer 1

Call time.Parse with a layout string such as "2006-01-02 15:04:05.999" on your time string. If that results in a valid time.Time value and no error then your string should work in the db.

timeStamp, err := time.Parse("2006-01-02 15:04:05.999", yourTimeString)
    if err != nil {
        // do something with err...
    }
// do something with timeStamp...

I don't use MySQL but between PostgreSQL and Go you can pass around timestamps and time.Time values without converting to strings... so maybe that simplifies your problem. Covert the string in Go using time.Parse and then write the time.Time value to the db.