数据表
1 seqID int 4 0
0 CardID varchar 10 1
0 MoneyCard varchar 80 0
0 AddDay int 4 0
0 SellMan varchar 20 1
0 HardCode varchar 40 1
0 CreateDays varchar 20 1
0 valid int 4 1
1 seqID int 4 0
0 CardID varchar 10 1
0 MoneyCard varchar 80 0
0 AddDay int 4 0
0 SellMan varchar 20 1
0 HardCode varchar 40 1
0 CreateDays varchar 20 1
0 valid int 4 1
跟sql語句沒关系,上述语句至少没问题
我估计是前台程式的问题。
时间格式都正确,都是getdate写进去的怎么看数据库日志啊,小弟现在一筹莫展啊
case when dateadd(dd,AddDay,CreateDays) > getdate() then 1 else 0 end as OnTime ,
(AddDay - datediff(dd,CreateDays,getdate())) as LeftDays
from CardInfor where CardID in (select CardID from OpenUser where HardCode='0000000000000000000000000')
and isdate(CreateDays)=1 ---加上這句試試.