今天早上碰到的,这样的转换就是会出错
cast('23:40:00' as datetime)
百思不得其解,百思不得其解,百思不得其解,最后检查数据库的数据发现有个数据值是24:00:00.这个是不能被转换的!!
所以大家以后碰到这样的问题,先看看有没有数据是24点...
相关文章
- [entity framework ] The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
- EF 6.0 The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value. c#中的时间
- conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
- The conversion of a varchar data type to a datetime data type resulted in an out-of-range value
- conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
- The conversion of a varchar data type to a datetime data type resulted in an out-of-range value
- The conversion of a varchar data type to a datetime data type resulted in an out-of-range value