Is there any posibilities to change the default Bind timestamp format in gin-gionic?

Question

I have a question in Go especially with gin-gionic and gorm.

Let's say I have model like this

// Classroom struct.
type Classroom struct {
    gorm.Model
    Name      string    `json:"name"`
    Code      string    `json:"code"`
    StartedAt time.Time `json:"started_at"`
}

I want to create data of Classroom Model with this JSON

{
  "name": "Math",
  "code": "math-mr-robie",
  "started_at": "2020-10-10 10:00:00"
}

But when I bind the JSON data, I got this following error

parsing time ""2020-10-10 10:00:00"" as ""2006-01-02T15:04:05Z07:00"": cannot parse " 10:00:00"" as "T"

I know that error appear because of the format that I sent was not the exact format of time.Time?

Is it possible to set default format of time.Time?

How to do that?

Because I've try to add .Format in after time.Time but error occurs.

// Classroom struct.
type Classroom struct {
    gorm.Model
    Name         string `json:"name"`
    Code         string `json:"code"`
    StartedAt    time.Time.Format("2006-01-02 15:04:05") `json:"started_at"`
}

There are many good solutions here [How to parse non standard time format from json](https://stackoverflow.com/questions/45303326/how-to-parse-non-standard-time-format-from-json) — Eklavya, Oct 21 '20 at 05:06
And in gin, you can do https://github.com/gin-gonic/gin#bind-query-string-or-post-data — Eklavya, Oct 21 '20 at 05:18
Hi @Eklavya thank you for the comment. But know I have issue ```sql: converting argument $6 type: unsupported type models.JSONDate, a struct``` I try to look up for this [Go Gorm Custom Data Type](https://github.com/go-gorm/datatypes/blob/master/date.go) — Yovi Prasetyo, Oct 21 '20 at 08:05

score 1 · Accepted Answer · answered Oct 21 '20 at 10:02

I resolve this issue by creating new struct JSONData that contain time inside it.

// JSONData struct.
type JSONData struct {
  Time time.Time
}

After I red Customize Data Types in Gorm and see some examples here then I add some methods


// Scan JSONDate.
func (j *JSONDate) Scan(value interface{}) (err error) {
    nullTime := &sql.NullTime{}
    err = nullTime.Scan(value)
    *j = JSONDate{nullTime.Time}
    return
}

// Value JSONDate.
func (j JSONDate) Value() (driver.Value, error) {
    y, m, d := time.Time(j.Time).Date()
    return time.Date(y, m, d, 0, 0, 0, 0, time.Time(j.Time).Location()), nil
}

// GormDataType gorm common data type
func (j JSONDate) GormDataType() string {
    return "timestamp"
}

For the gin things. Another resource @Eklavya given. So I add another methods.


// UnmarshalJSON JSONDate.
func (j *JSONDate) UnmarshalJSON(b []byte) error {
    s := strings.Trim(string(b), "\"")
    t, err := time.Parse(helpers.YMDHIS, s)
    if err != nil {
        return err
    }
    *j = JSONDate{
        Time: t,
    }
    return nil
}

// MarshalJSON JSONDate.
func (j JSONDate) MarshalJSON() ([]byte, error) {
    return []byte("\"" + j.Time.Format(helpers.YMDHIS) + "\""), nil
}

// Format method.
func (j JSONDate) Format(s string) string {
    t := time.Time(j.Time)
    return t.Format(helpers.YMDHIS)
}

And it's works!

Using gin you can use _time_format_ Ex: _Birthday time.Time `time_format:"2006-01-02"`_ — Eklavya, Oct 22 '20 at 04:04
@Eklavya I've try that one but can't still parse the time format I use. ```2006-01-02 15:04:05``` — Yovi Prasetyo, Oct 22 '20 at 06:59

score 0 · Answer 2 · answered Jun 08 '22 at 07:12

I came across this question with the same issue and found that if you are looking for a specific time format like the ISOStrings sent from the browser you can have something like this;

type Classroom struct {
    gorm.Model
    Name      string    `json:"name"`
    Code      string    `json:"code"`
    StartedAt time.Time `json:"started_at" time_format:"RFC3339"`
}

With the time_format I did not need to define marshal functions to handle the formatting. However, if you need to do a completely custom format for your date and time then I believe you will need to define these functions.

Is there any posibilities to change the default Bind timestamp format in gin-gionic?

2 Answers2