Golang中的RFC3339时间解析

Question

I'm pulling a timestamp from a datebase, it is using RFC3339 format but the timezone is missing. So when I try to compare the timestamps it will be off. How do I change dbtime to be Eastern time?

// time format
const
(
    RFC3339     = "2006-01-02T15:04:05Z07:00"
)

//now time
now := time.Now()
nowtime := now.Unix()

fmt.Println("Nowtime:", nowtime)
fmt.Println("Now:", now)

//time in db
fmt.Println("Dbtime string:", dbtime)
udbtime, err := time.Parse.EST(RFC3339,dbtime)
fmt.Println("RFC3339: " + RFC3339)
fmt.Println("dbtime parsed", udbtime)
fmt.Println("dbtime parsed unixtime", udbtime.Unix())

My output is

Nowtime: 1466443640
Now: 2016-06-20 13:27:20.963232824 -0400 EDT
Dbtime string: 2016-06-20T12:41:45.14Z
RFC3339: 2006-01-02T15:04:05Z07:00
dbtime parsed 2016-06-20 12:41:45.14 +0000 UTC
dbtime parsed unixtime 1466426505

Answer 1

If you're 100% sure the timezone in the database is incorrect, you can convert it like this

t2 := time.Date(
    t.Year(),
    t.Month(),
    t.Day(),
    t.Hour(),
    t.Minute(),
    t.Second(),
    t.Nanosecond(),
    time.FixedZone("EDT", -4*60*60),
)