将MySQL日期时间字符串转换为time.Time格式

Question

I just cant manage to parse an SQL datetime (MySQL) value into a time.Time value. I cant find the layout fitting sql datetime. And also not really understand how this works.

I do imagine I'am not the first struggling with this, though i cant really find how I should make this work.

Input:

2015-12-23 00:00:00

Desired output:

1450825200

Code

time, err := time.Parse(time.SomeSqlDateTimeLayout, "2015-12-23 00:00:00")
timestamp := time.Unix()

Answer 1

You can create your own tie format for parsing, if one does not exist in standard library.

package main

import (
    "fmt"
    "time"
)

func main() {
    layout := "2006-01-02 15:04:05"
    str := "2015-12-23 00:00:00"
    t, err := time.Parse(layout, str)

    if err != nil {
        fmt.Println(err)
    }
    fmt.Println(t.Unix())
}

Output

1450828800

I do not know were official documentation for time format is, but you can find it here, from line 64.