today´s date: 2003-07-01 Hi there,,, I wrote down this statement select (current_date - 1 )
and the result was: -------------------- (Currentdate -1) ------------------- 20030700 when i write select (current_date ) I have: -------------------- (Currentdate) ------------------- 2003-07-01 but actually, I wanna a result like that.... select (current_date - 1 ) as result -------------------- (Currentdate -1) ------------------- 2003-06-30 can you help me, please?
