issue: 从postgresql查询timestamp类型数据，指针time和非指针time数据异常 #1848

New Issue

mikoto · 2021-01-04T03:15:56Z

mikoto commented

2021-01-04 03:15:56 +00:00

code:

package main

import (
	"fmt"
	_ "github.com/jackc/pgx/v4/stdlib"
	_ "github.com/lib/pq"
	"time"
	"xorm.io/xorm"
)

type MyPointerTime struct {
	ID         int       `xorm:"id" json:"id"`
	CreateTime *time.Time `xorm:"create_time" json:"create_time"`
}

type MyTime struct {
	ID         int       `xorm:"id" json:"id"`
	CreateTime time.Time `xorm:"create_time" json:"create_time"`
}

func main()  {
	dbUrl := "user=postgres password=111111 host=127.0.0.1 port=5432 dbname=postgres search_path=test sslmode=disable"
	engine, err := xorm.NewEngine("pgx", dbUrl)
	if err !=nil {
		fmt.Println(err.Error())
		return
	}
	var pt [] MyPointerTime
	var t [] MyTime
	err = engine.SQL("SELECT * FROM point_time").Find(&pt)
	err = engine.SQL("SELECT * FROM point_time").Find(&t)
	if err !=nil {
		fmt.Println(err.Error())
		return
	}
	fmt.Println("Xorm Pointer Time Result: ",pt[0],pt[0].CreateTime.Unix())
	fmt.Println("Xorm Time Result:         ",t[0],t[0].CreateTime.Unix())
}

OutPut:

Xorm Pointer Time Result:  {3 2021-01-04 10:54:58.849671 +0800 CST} 1609728898
Xorm Time Result:          {3 2021-01-04 02:54:58.849671 +0800 CST} 1609700098

### code: ```go package main import ( "fmt" _ "github.com/jackc/pgx/v4/stdlib" _ "github.com/lib/pq" "time" "xorm.io/xorm" ) type MyPointerTime struct { ID int `xorm:"id" json:"id"` CreateTime *time.Time `xorm:"create_time" json:"create_time"` } type MyTime struct { ID int `xorm:"id" json:"id"` CreateTime time.Time `xorm:"create_time" json:"create_time"` } func main() { dbUrl := "user=postgres password=111111 host=127.0.0.1 port=5432 dbname=postgres search_path=test sslmode=disable" engine, err := xorm.NewEngine("pgx", dbUrl) if err !=nil { fmt.Println(err.Error()) return } var pt [] MyPointerTime var t [] MyTime err = engine.SQL("SELECT * FROM point_time").Find(&pt) err = engine.SQL("SELECT * FROM point_time").Find(&t) if err !=nil { fmt.Println(err.Error()) return } fmt.Println("Xorm Pointer Time Result: ",pt[0],pt[0].CreateTime.Unix()) fmt.Println("Xorm Time Result: ",t[0],t[0].CreateTime.Unix()) } ``` ### OutPut: ``` Xorm Pointer Time Result: {3 2021-01-04 10:54:58.849671 +0800 CST} 1609728898 Xorm Time Result: {3 2021-01-04 02:54:58.849671 +0800 CST} 1609700098 ```

mikoto started working 2021-01-04 03:19:13 +00:00

mikoto canceled time tracking 2021-01-04 03:20:21 +00:00

mikoto started working 2021-01-04 03:22:39 +00:00

mikoto stopped working 2021-01-04 03:22:46 +00:00

7s

lunny commented

2021-01-04 06:38:28 +00:00

Yes, pgx driver has some problems with time. This is a known issue.

lunny added the

kind

bug

label 2021-01-04 06:38:37 +00:00