no output for to_date function

[arulkumara]

Hi,

I want to diaplay hi message if system date is equl to given date.
I tried one simple script.
But it doesn't show any output

what is problem with to_date function.

script:
*********************

 
set serveroutput on
 
begin
 
if sysdate=to_date('23-11-2007','DD-MM-YYYY')  then
dbms_output.put_line('Hi');
 
end if;
 
end;
 
 

SQL> @hai.sql

PL/SQL procedure successfully completed.

[amitpatel66]

Hi,

I want to diaplay hi message if system date is equl to given date.
I tried one simple script.
But it doesn't show any output

what is problem with to_date function.

script:
*********************
set serveroutput on

begin

if sysdate=to_date('23-11-2007','DD-MM-YYYY') then
dbms_output.put_line('Hi');

end if;

end;

SQL> @hai.sql

PL/SQL procedure successfully completed.

Try this:

 
select 1 from dual WHERE TO_DATE(SYSDATE,'DD-MM-YYYY') = TO_DATE('23-11-2007','DD-MM-YYYY')
 
SQL> /
 
        1
---------
        1
 
select 1 from dual WHERE TRUNC(SYSDATE) = TO_DATE('23-11-2007','DD-MM-YYYY')
 
SQL> /
 
        1
---------
        1
 
 

You need to either TRUNCATE the SYSDATE or convert the SYSDATE to the particular format for perfect comparisons.

[nramrits]

Hi,

I want to diaplay hi message if system date is equl to given date.
I tried one simple script.
But it doesn't show any output

what is problem with to_date function.

script:
*********************
set serveroutput on

begin

if sysdate=to_date('23-11-2007','DD-MM-YYYY') then
dbms_output.put_line('Hi');

end if;

end;

SQL> @hai.sql

PL/SQL procedure successfully completed.

hi
please use the to_date funtion in sysdate , because sysdate contain a time , min,seconds so that the if condition is return false.
if to_date(sysdate) =to_date('23-11-2007','DD-MM-YYYY') then

[amitpatel66]

Please enclose your posted code in [code] tags (See How to Ask a Question).

This makes it easier for our Experts to read and understand it. Failing to do so creates extra work for the moderators, thus wasting resources, otherwise available to answer the members' questions.

Please use [code] tags in future.

MODERATOR

[QVeen72]

Hi,

There is no need to convert it to date both sides, check this way :

set serveroutput on
begin
IF TO_CHAR(SYSDATE,'DD-MM-YYYY') ='23-11-2007'  THEN
    dbms_output.put_line('Hi');
end if;
end;
 

Regards
Veena

[Dharmaraju]

Try this:

 
select 1 from dual WHERE TO_DATE(SYSDATE,'DD-MM-YYYY') = TO_DATE('23-11-2007','DD-MM-YYYY')
 
SQL> /
 
        1
---------
        1
 
select 1 from dual WHERE TRUNC(SYSDATE) = TO_DATE('23-11-2007','DD-MM-YYYY')
 
SQL> /
 
        1
---------
        1
 
 

You need to either TRUNCATE the SYSDATE or convert the SYSDATE to the particular format for perfect comparisons.

/****************** TRY THIS********************/

hi may be the time part will not match to that date so use truncate for sysdate then we can compare the condition

set serveroutput on
begin
select trunc(to_date(sysdate))=to_date('03/12/2007','dd/mm/yyyy') from dual;
dbms_output.put_line('hi');
end;

/******************** I THINK IT CAN BE USE******************/