ex:
select * from wms_cadlot where
DATFIMLOT BETWEEN :DTLOTINI AND :DTLOTFIN
DTLOTINI = 03/10/2012 AND DTLOTFIN = 03/10/2012
DTLOTINI = 03/10/2012 AND DTLOTFIN = 04/10/2012
select * from wms_cadlot where
DATFIMLOT BETWEEN :DTLOTINI AND :DTLOTFIN
DTLOTINI = 03/10/2012 AND DTLOTFIN = 03/10/2012
DTLOTINI = 03/10/2012 AND DTLOTFIN = 04/10/2012
select * from tb where dtlotin >= to_date(01/01/2012,'dd/mm/yyyy') AND dtlotfim < to_date(02/01/2012,'dd/mm/yyyy') + 1
select * from tb where dtlotin between to_date(trunc(01/01/2012,'dd/mm/yyyy'))
AND dtlotfim to_date(trunc(02/01/2012,'dd/mm/yyyy'))
select *
from wms_cadlot
where DATFIMLOT >= to_date(:dataini,'dd/mm/yyyy')
AND DATFIMLOT < to_date(:datafim,'dd/mm/yyyy') + 1
select * from wms_cadlot where DATINICIOLOT >= to_date(dataini,'dd/mm/yyyy')
AND DATFIMLOT < to_date(datafim,'dd/mm/yyyy')
dtlotin between to_date('01/01/2012 00:00:00', 'dd/mm/yyyy hh24:mi:ss) AND to_date('01/01/2012 23:59:59', 'dd/mm/yyyy hh24:mi:ss)
Usuários navegando neste fórum: Nenhum usuário registrado e 5 visitantes