/* VIGENTE NO PERIODO ENTRE (DataInicio) E (DataFim) */
AND ( ( AVAIL_START_DATE <= :DataInicio AND AVAIL_END_DATE >= :DataFim ) OR ( AVAIL_START_DATE BETWEEN :DataInicio AND :DataFim ) )
/* COM TO_DATE NAS DATAS */
AND ( ( TO_DATE(PU.AVAIL_START_DATE, 'YYYYMMDD') <= :DataInicio AND TO_DATE(PU.AVAIL_END_DATE, 'YYYYMMDD') >= :DataFim ) OR ( TO_DATE(PU.AVAIL_START_DATE, 'YYYYMMDD') BETWEEN :DataInicio AND :DataFim ) )
Be the first to comment
You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.