Gorm 处理时间为string类型

发布时间 2023-06-09 16:37:30作者: TaylorSWMM

Gorm 处理时间为string类型

标签(空格分隔): go,gorm


package _type

import (
	"database/sql/driver"
	"fmt"
	"time"
)

type TimeString time.Time

func (s *TimeString) MarshalJSON() ([]byte, error) {
	tmp := time.Time(*s)
	return []byte(fmt.Sprintf("\"%s\"", tmp.Format("2006-01-02 15:04:05"))), nil
}

// Scan 实现sql.Scan接口
func (s *TimeString) Scan(src interface{}) error {
	switch v := src.(type) {
	case time.Time:
		*s = TimeString(v)
	default:
		return fmt.Errorf("time string scan error")
	}
	return nil
}

// Value 实现 driver.Valuer 接口
func (s TimeString) Value() (driver.Value, error) {
	tTime := time.Time(s)
	return tTime.Format("2006-01-02 15:04:05"), nil
}

func (s TimeString) String() string {
	return time.Time(s).Format("2006-01-02 15:04:05")
}

func (s TimeString) ToTime() time.Time {
	return time.Time(s)
}