oracle sql日期比較:
在今天之前:select?*?from?up_date?where?update?<?to_date('2007-09-07?00:00:00','yyyy-mm-dd?hh24:mi:ss')
select?*?from?up_date?where?update?<=?to_date('2007-09-07?00:00:00','yyyy-mm-dd?hh24:mi:ss')
在今天只后:select?*?from?up_date?where?update?>?to_date('2007-09-07?00:00:00','yyyy-mm-dd?hh24:mi:ss')
select?*?from?up_date?where?update?>=?to_date('2007-09-07?00:00:00','yyyy-mm-dd?hh24:mi:ss')
精確時間:select?*?from?up_date?where?update?=?to_date('2007-09-07?00:00:00','yyyy-mm-dd?hh24:mi:ss')
在某段時間內:select?*?from?up_date?where?update?between?to_date('2007-07-07?00:00:00','yyyy-mm-dd?hh24:mi:ss')?and?to_date('2007-09-07?00:00:00','yyyy-mm-dd?hh24:mi:ss')
select?*?from?up_date?where?update?<?to_date('2007-09-07?00:00:00','yyyy-mm-dd?hh24:mi:ss')?and?update?>?to_date('2007-07-07?00:00:00','yyyy-mm-dd?hh24:mi:ss')
select?*?from?up_date?where?update?<=?to_date('2007-09-07?00:00:00','yyyy-mm-dd?hh24:mi:ss')?and?update?>=?to_date('2007-07-07?00:00:00','yyyy-mm-dd?hh24:mi:ss')
posted on 2007-09-07 16:29
forker 閱讀(88483)
評論(6) 編輯 收藏 所屬分類:
database