INTERVAL '1' MONTH TO MONTH

来源：互联网发布：局域网办公聊天软件编辑：程序博客网时间：2024/04/30 19:36

INTERVAL 'integer [- integer]' {YEAR | MONTH} [(precision)][TO {YEAR | MONTH}]

该数据类型常用来表示一段时间差, 注意时间差只精确到年和月. precision为年或月的精确域, 有效范围是0到9, 默认值为2.

SELECT TRUNC(V.XF_TXDATE, 'MM') TXMONTH, V.XF_PLU, V.XF_STYLE, I.XF_DESCI, M88YR, M72APOSSNCOD,
   V.XF_AMTSOLD, V.XF_QTYSOLD, V.XF_AMTSOLD / V.XF_QTYSOLD UNIT_PRICE, V.XF_TTLORGUPRICE / V.XF_QTYSOLD ORG_UNIT_PRICE
  FROM ST1HKA.XF_VIPITEMDM V, ST1HKA.XF_ITEMMAS I, ZTM99, ZTM70, ZTM72A, ZTM88
  WHERE
   V.XF_QTYSOLD <> 0 AND V.XF_PLU = I.XF_PLU AND V.XF_STORECODE = M99STOCOD
   AND M99MRKCOD = M70MKTCOD AND M70MKTGRP = 'HK'
   AND I.XF_GROUP0 = M88PLUYR AND I.XF_GROUP1 = M72APLUSSNCOD
   AND M88YR IN ('2011', '2012')
   AND M72APOSSNCOD IN ('SS', 'AW')
   AND I.XF_GROUP4 IN ('G', 'Z')
   --AND I.XF_GROUP5 = :supplierCode
   AND (V.XF_TXDATE >= TRUNC(:startMonth, 'MM') OR :startMonth IS NULL)
   AND (V.XF_TXDATE < (TRUNC(:endMonth, 'MM') + INTERVAL '1' MONTH TO MONTH) OR :endMonth IS NULL)