to:zmgowin(隐者(龙祖宗)
请你解答我的疑问好不好:
select
(to_date('2004-9-1 9:30','yyyy-mm-dd HH24:MI') - to_date('2004-9-1 8:30','yyyy-mm-dd HH24:MI'))*60*24 as Date From WaterList
这个错在哪里?对的又如何写?
请你解答我的疑问好不好:
select
(to_date('2004-9-1 9:30','yyyy-mm-dd HH24:MI') - to_date('2004-9-1 8:30','yyyy-mm-dd HH24:MI'))*60*24 as Date From WaterList
这个错在哪里?对的又如何写?
select
(to_date(WaterTime,'yyyy-mm-dd HH24:MI') - to_date('2004-9-1 8:30','yyyy-mm-dd HH24:MI'))*60*24 as Date From WaterList
================================================
错在那里?
(to_date(WaterTime) - to_date('2004-9-1 8:30','yyyy-mm-dd HH24:MI'))*60*24 as Date From WaterList
watertime的存储是什么格式:是如 2004-9-19 8:30这样的格式!
(to_date(WaterTime) - to_date('2004-9-1 8:30','yyyy-mm-dd HH24:MI'))*60*24 as Date From WaterList
=============================================
?????
你没搞错?to_date(WaterTime)这样写?
select
(to_date(WaterTime,'yyyy-mm-dd HH24:MI:SS') - to_date('2004-9-1 8:30:01','yyyy-mm-dd HH24:MI:SS'))
from WaterList
=================================