How to define date in GORM

Defining date fields in GORM typically involves using the Go time.Time type to ensure dates are handled correctly. GORM is a popular Go ORM (Object-Relational Mapping) library that allows developers to map database tables using Go structs.

Here is a specific example illustrating how to define a model with date fields in GORM using the time.Time type:

go
package main

import (
	"gorm.io/gorm"
	"gorm.io/driver/sqlite"
	"time"
)

// Define a User model that includes basic user information and creation time
// type User struct {
//     gorm.Model
//     Name      string
//     Email     string
//     Birthday  time.Time
//     CreatedAt time.Time
// }

func main() {
    // Initialize database connection
    db, err := gorm.Open(sqlite.Open("test.db"), &gorm.Config{})
    if err != nil {
        panic("failed to connect database")
    }

    // Auto-migration mode to automatically create database table structure
    db.AutoMigrate(&User{})

    // Create a new user
    user := User{Name: "John Doe", Email: "john@example.com", Birthday: time.Date(1990, time.January, 1, 0, 0, 0, 0, time.UTC)}
    db.Create(&user)
}

In this example, we define a User struct that includes several fields: Name, Email, Birthday, and CreatedAt. Both the Birthday and CreatedAt fields are defined using the time.Time type. The Birthday field represents the user's birthday, while the CreatedAt field represents the time when the user record was created. Both fields will be stored in the database in date-time format.

Using GORM's AutoMigrate feature, we can automatically create the corresponding database table structure without manually writing SQL statements. This is very helpful for rapid development and reducing errors.

When inserting data, the CreatedAt field is automatically set to the current time by GORM because the CreatedAt field is included in gorm.Model and configured with its default behavior. The Birthday field, however, must be explicitly provided when creating a user.

This approach simplifies interaction with the database and makes date and time management clear and consistent.