MySQL Time test

time.go

package main

import (
	"database/sql"
	"fmt"
	_ "github.com/go-sql-driver/mysql"
	"time"
)

func main() {
	dsn := "root:@tcp(127.0.0.1:3306)/test?parseTime=True"
	db, err := sql.Open("mysql", dsn)
	_, err = db.Exec("drop table if exists t_time;")
	if err != nil {
		panic(err)
	}
	_, err = db.Exec("create table t_time (c Time);")
	if err != nil {
		panic(err)
	}
	_, err = db.Exec("insert into t_time values (?);", time.Now())
	if err != nil {
		panic(err)
	}
	row := db.QueryRow("select * from t_time;")
	var c string
	row.Scan(&c)
	fmt.Println(c)
}