mysqljs/mysql

0000-00-00 00:00:00 timestamp is returned as a string

Open

#1,040 创建于 2015年3月27日

在 GitHub 查看
 (8 评论) (0 反应) (1 负责人)JavaScript (18,137 star) (2,502 fork)batch import
help wantedquestion

描述

this should be equal to new Date(0) I believe. Here is what i 've done to make sure I always get a date:

if (typeof result.my_col ==="string"){
              result.my_col=new Date(0);
}
/*instanceof Date can also be used
or to cover only that case something like this:
result.my_col ==="0000-00-00 00:00:00"
but I don't remember if the above was the exact string given
*/

The rest of the timestamps is returned as dates so I wouldn't expect this behavior

贡献者指南

技术栈
javascriptnodejssqlmysql
领域
backenddatabase
议题类型
bug
难度面向新贡献者的预计实现难度，1 表示很小改动，5 表示专家级工作。
2
预计时间有经验贡献者完成调查、实现、测试并准备 pull request 的粗略时间范围。
1-3 hours
活动状态议题当前的可参与程度：新鲜、活跃、陈旧、阻塞或等待维护者输入。
stale
清晰度议题是否清楚说明期望改动、验收标准和下一步。
clear
前置要求
JavaScriptMySQL timestamp handling
新手友好度1-100 的估计分数，表示该议题对首次贡献者的友好程度。
70
研究方向
Look at the MySQL client's date parsing logic, likely in the connection or type casting code. Consider how zero dates are handled, as they are invalid dates in MySQL but often stored as '0000-00-00'. The fix should return a Date object (e.g., new Date(0)) instead of a string. Check the existing code to ensure consistency with other timestamp conversions.