So I'm trying to parse a time from a string and then insert that time into Postgres.
I have this so far-
layout := "2006-01-02T15:04:05.000Z"
updatedAt, _ := time.Parse("2016-06-10")
fmt.Println(updatedAt)
but this outputs
0001-01-01 00:00:00 +0000 UTC.
I'm also not sure how to then use this to query in postgres (what format should the time have)?
To parse time in your example you'll need correct layout passed to time.Parse:
layout := "2006-01-02"
updatedAt, _ := time.Parse(layout, "2016-06-10")
fmt.Println(updatedAt)
Outputs:
$ go run time.go
2016-06-10 00:00:00 +0000 UTC
To insert time you have after parsing it you'll just need to pass time.Time object to db.Exec. For example:
db.Exec("INSERT INTO tablename VALUES (time_column) (($1));", time.Now())