duandou8457 2019-08-21 08:41
浏览 1438
已采纳

如何将Go time.Time转换为MySQL datetime? [关闭]

I am generating a datetime string in Go and when I insert the generated value into a MySQL table, the value of the column becomes: 0000-00-00 00:00:00 but it is supposed to be: 2019-08-21 11:05:45.

I do not understand why the datetime becomes zero, I guess there is some mismatch.

goDateTime := time.Now().Format("02-01-2006 03:04:05") 

The above code returns datetime as a string. But in my database table the column type is datetime. I changed the database type to varchar and it worked, but I want to use the datetime time.

  • 写回答

1条回答 默认 最新

  • duankangzi766767 2019-08-21 08:46
    关注

    Your date format string is not compatible with MySQL. It should be

    golangDateTime := time.Now().Format("2006-01-02 15:04:05") 
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 Python动态规划:图2箭头指向的代码如何理解?太抽象了
  • ¥100 X轴为分离变量(因子变量),如何控制X轴每个分类变量的长度。
  • ¥30 求给定范围的全体素数p的(p-2)的连乘积
  • ¥15 VFP如何使用阿里TTS实现文字转语音?
  • ¥100 需要跳转番茄畅听app的adb命令
  • ¥50 寻找一位有逆向游戏盾sdk 应用程序经验的技术
  • ¥15 请问有用MZmine处理 “Waters SYNAPT G2-Si QTOF质谱仪在MSE模式下采集的非靶向数据” 的分析教程吗
  • ¥50 opencv4nodejs 如何安装
  • ¥15 adb push异常 adb: error: 1409-byte write failed: Invalid argument
  • ¥15 nginx反向代理获取ip,java获取真实ip