BOS开发单据，编写报表如何将过滤条件显示为长日期字段
150xxxx9749
390次浏览
编辑于2019年08月23日 15:45:36
SELECT
ZRQ AS 日期,
GK AS 港口,
JHH AS 计划号,
CD AS 车队,
sum(JZ) as 净重
from(SELECT
t2.FTime as ZRQ,
t1.FText6 as GK ,
t2.FText as CM,
t2.FText1 as JHH,
t2.FText4 as CD,
t2.FDecimal as JZ
FROM t_BOS200000004 t1
INNER JOIN t_BOS200000004Entry2 t2 ON t1.FID= t2.FID AND T1.FText6 like '%京唐港%'
and t2.FTime>='********' and t2.FTime<='########')v group by JHH,ZRQ,GK,CD
如何将日期过滤字段t2.FTime>='********' and t2.FTime<='########'修改为长日期字段？
推荐阅读