我试图在Go中将一些值从我的数据库添加到[]字符串.其中有些是时间戳.

我得到错误:

cannot use U.Created_date (type time.Time) as type string in array element

可以将time.Time转换成字符串吗?

type UsersSession struct {
    Userid int
    Timestamp time.Time
    Created_date time.Time
}

type Users struct {
    Name string
    Email string
    Country string
    Created_date time.Time
    Id int
    Hash string
    IP string
}

var usersArray = [][]string{}

rows,err := db.Query("SELECT u.id,u.hash,u.name,u.email,u.country,u.IP,u.created_date,us.timestamp,us.created_date FROM usersSession AS us LEFT JOIN users AS u ON u.id = us.userid WHERE us.timestamp + interval 30 minute >= now()")

U := Users{}
US := UsersSession{}

for rows.Next() {
    err = rows.Scan(&U.Id,&U.Hash,&U.Name,&U.Email,&U.Country,&U.IP,&U.Created_date,&US.Timestamp,&US.Created_date)
    checkErr(err)

    userid_string := strconv.Itoa(U.Id)
    user := []string{userid_string,U.Hash,U.Name,U.Email,U.Country,U.IP,U.Created_date,US.Timestamp,US.Created_date}
    // -------------
    // ^ this is where the error occurs
    // cannot use U.Created_date (type time.Time) as type string in array element (for US.Created_date and US.Timestamp aswell)
    // -------------

    usersArray = append(usersArray,user)
    log.Print("usersArray: ",usersArray)
}

编辑

我添加了以下内容.现在工作,谢谢.

userCreatedDate := U.Created_date.Format("2006-01-02 15:04:05")
userSessionCreatedDate := US.Created_date.Format("2006-01-02 15:04:05")
userSessionTimestamp := US.Timestamp.Format("2006-01-02 15:04:05")
您可以使用
Time.String()
方法将
time.Time
转换为字符串.这使用格式字符串“2006-01-02 15:04:05.999999999 -0700 MST”.
Time.Format()

例:

t := time.Now()
fmt.Println(t.String())
fmt.Println(t.Format("2006-01-02 15:04:05"))

输出(尝试在Go Playground):

2009-11-10 23:00:00 +0000 UTC
2009-11-10 23:00:00

注意:Go游乐场上的时间总是设置为上述值.在本地运行以查看当前日期/时间.

另请注意,使用Time.Format()作为布局字符串,您始终必须通过相同的时间 – 以您希望格式化结果的方式将参考时间格式化.这是在Time.Format()中记录的:

Format returns a textual representation of the time value formatted according to layout,which defines the format by showing how the reference time,defined to be

06002

would be displayed if it were the value; it serves as an example of the desired output. The same display rules will then be applied to the time value.