write a sql sentence?

[chinabluesky]

in A table ,there are two column,they are code char(10) ,txdate date
請列出TXDATE1-TXDATE2>6 month

[chinabluesky]

in A table ,there are two column,they are code char(10) ,txdate date
請列出TXDATE1-TXDATE2>6 month 的code

[pbdesigner]

可参照如下语句：
select code
from a
where DATEDIFF(month, startdate, enddate) > 6
注：startdate为小的日期,enddate为大的日期

[chinabluesky]

我需要startdate,startdate是不定的,僅限enddate-startdate>6就行了

[pbdesigner]

datediff()的第一个参数是datepart，可以是year,quarter,month,dayofyear,day,week,hour,minute,second,millisecond，startdate和enddate可以是变量

[chinabluesky]

in the pb,may use the datediff?whay function is it?

[chinabluesky]

在這里,startdate ,和enddate 也不是變量

[pbdesigner]

同样可以用在PB，只不过变量必须用而已.

[chinabluesky]

select plu
from itemdm
where DATEDIFF(month, '2000-01-01', '2001-01-01') > 6;
和
SELECT PLU
FROM ITEMDM;

返回的紀錄數是一樣的
why?

[pbdesigner]

当然，条件永远为真不等于无条件吗。'2000-01-01'到 '2001-01-01'有12个月啦,当然比6大

[wangsw]

select * from table where dateiff(year,convert(datetime,field1,102),convert(datetime,field2,102))*12+dateiff(month,convert(datetime,field1,102),convert(datetime,field2,102))>6 ;

[chinabluesky]

field1 ,field 可以為一個字段么
102 是什么意思?

[chinabluesky]

select plu
from itemdm
where datediff(year,convert(datetime,txdate,102),convert(datetime,txdate,102))*12+datediff(month,convert(datetime,txdate,102),convert(datetime,txdate,102))>6 ;
返回行為0;
why?
helop

[Methodor]

同一个字段你用什么datediff函数-开玩笑~~
呵呵~~
102是转换为ansi标准：yy.mm.dd的格式~~

[pbdesigner]

up

[hzslx]

up