SELECT zyh AS 住院号, brxm AS 病人姓名, ryks AS 入院科室, ryrq AS 入院日期, cyrq AS 出院日期,
jsdh AS 结算代号, jsrq AS 结算日期, djrq AS 登记日期
FROM zysf_cydj
where ryks='0030'and djrq>'2008-02-20 00:00:00:000<2010-02-20 00:00:00:000'
执行时 提示 从字符串转换为 datetime 时发生语法错误。表中的时间格式为“0000-00-00 00:00:00:000”求高手指点
jsdh AS 结算代号, jsrq AS 结算日期, djrq AS 登记日期
FROM zysf_cydj
where ryks='0030'and djrq>'2008-02-20 00:00:00:000<2010-02-20 00:00:00:000'
执行时 提示 从字符串转换为 datetime 时发生语法错误。表中的时间格式为“0000-00-00 00:00:00:000”求高手指点
SELECT zyh AS 住院号, brxm AS 病人姓名, ryks AS 入院科室, ryrq AS 入院日期, cyrq AS 出院日期,
jsdh AS 结算代号, jsrq AS 结算日期, djrq AS 登记日期
FROM zysf_cydj
where ryks='0030'and djrq>'2008-02-20 00:00:00:000' AND djrq<'2010-02-20 00:00:00:000'
jsdh AS 结算代号, jsrq AS 结算日期, djrq AS 登记日期
FROM zysf_cydj
where ryks='0030'
and convert(djrq,datetime,120) between '2008-02-20 00:00:00:000' and '2010-02-20 00:00:00:000'
convert(ryrq,datetime,120) AS 入院日期, convert(cyrq,datetime,120) AS 出院日期,
jsdh AS 结算代号, jsrq AS 结算日期, djrq AS 登记日期
FROM zysf_cydj
where ryks='0030'and
convert(djrq,datetime,120) between '2008-02-20 00:00:00:000' and '2010-02-20 00:00:00:000'
SELECT zyh AS 住院号, brxm AS 病人姓名, ryks AS 入院科室, ryrq AS 入院日期, cyrq AS 出院日期,
jsdh AS 结算代号, jsrq AS 结算日期, djrq AS 登记日期
FROM zysf_cydj
where ryks='0030'and djrq between '2008-02-20 00:00:00:000' AND '2010-02-20 00:00:00:000'
SELECT zyh AS 住院号, brxm AS 病人姓名, ryks AS 入院科室, ryrq AS 入院日期, cyrq AS 出院日期,
jsdh AS 结算代号, jsrq AS 结算日期, convert(varchar,djrq,102)+' '+convert(varchar,djrq,108) AS 登记日期
FROM zysf_cydj
where djrq>convert(datetime,'2008-02-20 00:00:00:000')
and djrq<convert(datetime,'2010-02-20 00:00:00:000')
and ryks='0030'
jsdh AS 结算代号, jsrq AS 结算日期, djrq AS 登记日期
FROM zysf_cydj
where ryks='0030'
and djrq between CONVERT(datetime,'2008-02-20 00:00:00:000',121) and CONVERT(datetime,'2010-02-20 00:00:00:000',121)