Gorm Object created and fetched do not match

GORM Playground Link

https://github.com/go-gorm/playground/pull/533

Description

I created user object and then called it from database but fields like CreatedAt, UpdatedAt and Delete do not match local region.

My console output:

[0.225ms] [rows:1] SELECT * FROM `users` WHERE `users`.`id` = 1 AND `users`.`deleted_at` IS NULL ORDER BY `users`.`id` LIMIT 1
    main_test.go:23: Failed, object not match:
        create: {Model:{ID:1 CreatedAt:2022-10-22 01:27:30.456916 +0300 +03 UpdatedAt:2022-10-22 01:27:30.456916 +0300 +03 DeletedAt:{Time:0001-01-01 00:00:00 +0000 UTC Valid:false}} Name:jinzhu Age:0 Birthday:<nil> Account:{Model:{ID:0 CreatedAt:0001-01-01 00:00:00 +0000 UTC UpdatedAt:0001-01-01 00:00:00 +0000 UTC DeletedAt:{Time:0001-01-01 00:00:00 +0000 UTC Valid:false}} UserID:{Int64:0 Valid:false} Number:} Pets:[] Toys:[] CompanyID:<nil> Company:{ID:0 Name:} ManagerID:<nil> Manager:<nil> Team:[] Languages:[] Friends:[] Active:false}
        get: {Model:{ID:1 CreatedAt:2022-10-22 01:27:30.456916 +0300 +0300 UpdatedAt:2022-10-22 01:27:30.456916 +0300 +0300 DeletedAt:{Time:0001-01-01 00:00:00 +0000 UTC Valid:false}} Name:jinzhu Age:0 Birthday:<nil> Account:{Model:{ID:0 CreatedAt:0001-01-01 00:00:00 +0000 UTC UpdatedAt:0001-01-01 00:00:00 +0000 UTC DeletedAt:{Time:0001-01-01 00:00:00 +0000 UTC Valid:false}} UserID:{Int64:0 Valid:false} Number:} Pets:[] Toys:[] CompanyID:<nil> Company:{ID:0 Name:} ManagerID:<nil> Manager:<nil> Team:[] Languages:[] Friends:[] Active:false}
--- FAIL: TestGORM (0.00s)
FAIL
FAIL    gorm.io/playground  0.435s
FAIL

! attention timezone

Comment From: ozkansen

I can temporarily bypass the local zone problem when we set the time zone to UTC:

func main() {
    db, err := gorm.Open(sqlite.Open(":memory:"), getGormConfig())
    if err != nil {
        panic(err)
    }

    ...
}

func getGormConfig() *gorm.Config {
    return &gorm.Config{NowFunc: useDefaultUTCTimeZone()}
}

func useDefaultUTCTimeZone() func() time.Time {
    var (
        loc *time.Location
        err error
    )

    if loc, err = time.LoadLocation("UTC"); err != nil {
        panic(err)
    }

    time.Local = loc

    return time.Now().Local
}

Comment From: a631807682

Yes, you need to specify NowFunc. The database allows different time rules for each table. We cannot help users decide what type of time to use.