Date Formatting Question
I am trying to figure out what I am missing here when trying to use to_char and to_date in my code
i have broken it down to just using sysdate and dual so if someone can help me on this i would appreciate it
if i do
select sysdate from dual where to_char(sysdate,'yyyy/mm/dd') = '2009/09/25';
i get
SYSDATE
---------
25-SEP-09
if i do
select sysdate from dual where sysdate = to_date ('2009/09/25','yyyy/mm/dd');
i get
no rows selected
so i cannot figure out why the second sql returns nothing