Re: Sysdate, help needed urgent:)
From: Edward W. Vergragt <E.W.Vergragt_at_inter.nl.net>
Date: 1996/08/07
Message-ID: <4u7ti4$cl1_at_grootstal.nijmegen.inter.nl.net>#1/1
Date: 1996/08/07
Message-ID: <4u7ti4$cl1_at_grootstal.nijmegen.inter.nl.net>#1/1
Kenny Liew <kenliew_at_pl.jaring.my> wrote:
>Anyone out there knows how can I pull rows out from a table using an SQL
>statement, where the date in the rows equals the current date?
select *
from table
where date_column
between to_date(to_char(sysdate,'DD-MON-YYYY')||'
00:00:00'),'DD-MON-YYYY HH24:MI:SS')
and
to_date(to_char(sysdate,'DD-MON-YYYY')||' 23:59:59'),'DD-MON-YYYY
HH24:MI:SS')
regards
edward vergragt
vergragt_at_inter.nl.net
SWM Automatisering - Bussum, the Netherlands
Edward W. Vergragt
vergragt_at_inter.NL.net
programmatuur voor handel in bulk-goederen (commodities), gebaseerd op het Oracle RDBMS software for commodity-traders, trafficers, Oracle-based Received on Wed Aug 07 1996 - 00:00:00 CEST