表里有3个字段分别记录了年月日如下------------------------------------------------
id OrderYear OrderMonth OrderDay
------------------------------------------------
1 2008 2 3
... ...想查某一天以前的日期怎么查,想查出来的记录集中的字段就是datetime型的,我试了下,不行select [Id],Cast([OrderYear]+'-'+[OrderMonth]+'-'+[OrderDay] as datetime) as [OrderTime]结果如下
-------------------------------------
id OrderTime
-------------------------------------
1 1905-07-07 00:00:00.000
... ...高手指点下哪里错了?
id OrderYear OrderMonth OrderDay
------------------------------------------------
1 2008 2 3
... ...想查某一天以前的日期怎么查,想查出来的记录集中的字段就是datetime型的,我试了下,不行select [Id],Cast([OrderYear]+'-'+[OrderMonth]+'-'+[OrderDay] as datetime) as [OrderTime]结果如下
-------------------------------------
id OrderTime
-------------------------------------
1 1905-07-07 00:00:00.000
... ...高手指点下哪里错了?
--tryselect [Id],Cast(rtrim([OrderYear])+'-'+rtrim([OrderMonth])+'-'+rtrim([OrderDay]) as datetime) as [OrderTime]
select [Id],Cast(str([OrderYear])+'-'+str([OrderMonth])+'-'+str([OrderDay]) as datetime) as [OrderTime]
这样也行。
select [Id],Cast(rtrim([OrderYear])+'-'+rtrim([OrderMonth])+'-'+rtrim([OrderDay]) as datetime) as [OrderTime] where [OrderTime] >= '2006-7-13 19:06:14'服务器: 消息 207,级别 16,状态 3,行 1
列名 'OverdueTime' 无效。
select [Id],Cast(rtrim([OrderYear])+'-'+rtrim([OrderMonth])+'-'+rtrim([OrderDay]) as datetime) as [OrderTime] where [OrderTime] >= '2006-7-13 19:06:14'服务器: 消息 207,级别 16,状态 3,行 1
列名 'OrderTime' 无效。