用MySQLDriverCS访问Mysql数据库访问到日期字段时出的错
我这里访问的是discuz库的cdb_members表,sql如下:
#set($sql = "SELECT * FROM `cdb_members` order by credits LIMIT 0 , 30")
结果报错,如下:
The DateTime represented by the string is not supported in calendar System.Globalization.GregorianCalendar.
我估计应该是和日期类型的字段有关系,然后就把select *改为select username,
#set($sql = "SELECT username,email,credits FROM `cdb_members` order by credits LIMIT 0 , 30")
结果正确返回数据,但是这是为什么呢?
新手,希望大家给与帮助,谢谢!
#set($sql = "SELECT * FROM `cdb_members` order by credits LIMIT 0 , 30")
结果报错,如下:
The DateTime represented by the string is not supported in calendar System.Globalization.GregorianCalendar.
我估计应该是和日期类型的字段有关系,然后就把select *改为select username,
#set($sql = "SELECT username,email,credits FROM `cdb_members` order by credits LIMIT 0 , 30")
结果正确返回数据,但是这是为什么呢?
新手,希望大家给与帮助,谢谢!