Kalau gak pake trunc aja, mis : if trunc(date1)=trunc(date2) then ....
cheers otto --- In [email protected], aly rmb <[EMAIL PROTECTED]> wrote: > > if to_date(a,'DD-MM-YYYY') = to_date(b,'DD-MM-YYYY') > dng data dibawah...ini akan menghasilkan TRUE ... > > tp klo ngga' pake format 'DD-MM-YYYY' make data akan di compare beserta jam-menit-detik ... > > Riky Kurniawan <[EMAIL PROTECTED]> wrote: > emang jawabannya apa mas? dishare atuh, jadi yg ga ngerti jd > ngerti...contohnya saya, hehehe > > On 25/01/2008, aly rmb <[EMAIL PROTECTED]> wrote: > > > > sorry ...sudah terjawab ...thx > > > > aly rmb <[EMAIL PROTECTED] <aly_rmb%40yahoo.com>> wrote: Salam semua, > > > > langsung saja ... > > > > misal > > a = 01-Jan-08 (date) > > b = 01-Jan-08 (date) > > > > waktu di compare > > > > a <= b hasilnya False > > > > Kenapa hasilnya bisa aneh ?! > > > > S/W yg di pake From 6i > > > > Salam/Aly > > > > Send instant messages to your online friends http://uk.messenger.yahoo.com > > > > [Non-text portions of this message have been removed] > > > > Send instant messages to your online friends http://uk.messenger.yahoo.com > > > > [Non-text portions of this message have been removed] > > > > > > > > [Non-text portions of this message have been removed] > > > > > > Send instant messages to your online friends http://uk.messenger.yahoo.com > > [Non-text portions of this message have been removed] >
