dongrui6787 2019-04-04 10:41
浏览 83
已采纳

无法将mysql中的时间戳值提取到time.Time变量中

I cannot get mysql timestamp value in into a time.Time variable

I am trying to scan a row, All values get successfully scanned except the timestamp type in mysql, I am already using dsn parseTime=true which was one of the issues i searched into, but it does not help

        type Tags struct {
            ID             int
            CreatedAt      time.Time `json:"created_at"`
        }
        func foo5() {
            http.HandleFunc("/tags/", bar5)
            http.ListenAndServe(":8080", nil)
        }

        func bar5(w http.ResponseWriter, r *http.Request) {
            db, err := sql.Open("mysql", "root:*******@/catalogue_service?parseTime=true")
            if err != nil {
            fmt.Println("error opening")
            }
            v, _ := strconv.Atoi(path.Base(r.URL.Path))
            row := db.QueryRow("select * from tags where id = ?", v)
            var myRow Tags
            row.Scan(&myRow.ID, &myRow.CreatedAt)
            fmt.Println(myRow)
        }

int and string values are displayed properly but CreatedAt prints 0001-01-01 00:00:00 +0000 UTC instead of the actual value

Edit:

 +-----------------+--------------------------+------+-----+-------------------+-----------------------------------------------+
| Field           | Type                     | Null | Key | Default           | Extra                                         |
+-----------------+--------------------------+------+-----+-------------------+-----------------------------------------------+
| id              | int(11)                  | NO   | PRI | NULL              | auto_increment                                |
| created_at      | timestamp                | NO   |     | CURRENT_TIMESTAMP | DEFAULT_GENERATED                             |
+-----------------+--------------------------+------+-----+-------------------+-----------------------------------------------+

| 84 | 2019-01-30 11:21:36 |

  • 写回答

2条回答 默认 最新

  • douzhao9608 2019-04-04 13:05
    关注

    Error has been resolved by myself, there were null values in the table which Scan could not handle hence i used sql.NULLString or mysql.NULLTime type in struct depending on the field

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)

报告相同问题?

悬赏问题

  • ¥15 nslt的可用模型,或者其他可以进行推理的现有模型
  • ¥15 arduino上连sim900a实现连接mqtt服务器
  • ¥15 vncviewer7.0安装后如何正确注册License许可证,激活使用
  • ¥15 phython如何实现以下功能?查找同一用户名的消费金额合并2
  • ¥66 关于人体营养与饮食规划的线性规划模型
  • ¥15 基于深度学习的快递面单识别系统
  • ¥15 Multisim仿真设计地铁到站提醒电路
  • ¥15 怎么用一个500W电源给5台60W的电脑供电
  • ¥15 请推荐一个轻量级规则引擎,配合流程引擎使用,规则引擎负责判断出符合规则的流程引擎模板id
  • ¥15 Excel表只有年月怎么计算年龄