Golang：转换yyyy：MM：dd hr：mm：ss即我正在以字符串形式获取日期，并且需要解析相同的日期才能保存在mysql数据库中

Question

layout := "2006-01-02 15:04:05"
    str := "2018-10-11 13:10:47"
    t, err := time.Parse(layout, str)

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

I am getting output as 2018-10-11 13:10:47 +0000 UTC, but I want to store in mysql db as 2018-10-11 13:10:47. How do I parse exactly for mysql datetime?

Answer 1

layout := "2006-01-02 15:04:05"
fmt.Println(t.Format(layout))

Output:

2018-10-11 13:10:47

---

For example,

package main

import (
    "fmt"
    "time"
)

func main() {
    layout := "2006-01-02 15:04:05"
    str := "2018-10-11 13:10:47"
    t, err := time.Parse(layout, str)

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

Playground: https://play.golang.org/p/NuloBCXBdhH

Output:

2018-10-11 13:10:47 +0000 UTC
2018-10-11 13:10:47