Extract time and compare dates
616075Feb 7 2008 — edited Feb 7 2008I would like to know if hh:mm:ss have following value : "00:00:00" but I can't extract those values from the date. I'm not interested in dd/mm/yy but they are included in the string I receive.
set serveroutput on;
declare
str varchar2(30);
dat date;
begin
str := '19/01/2008 00:00:00';
dat := to_date(pepe,'HH24:MI:SS'); -- can't do this because mask do not fit with input string
if dat = '00:00:00' then ....