Hi Marthen,
Bener banget emg beda :( saya pake to_date baru bener. Thanks in advance On 11/8/07, Marthen LT <[EMAIL PROTECTED]> wrote: > Hi Harry, > > ya jelas beda, hasil dari parser to_char adalah string (varchar). > di string data type, '06/11/2007' tidak sama dengan '6/11/2007'. > > coba kalau pembandingnya anda gunakan datetime, misal select.........where > date_time between TIMESTAMP'2007-10-01 00:00:00' and TIMESTAMP'2007-11-06 > 00:00:00' (atau TIMESTAMP'2007-11-6 00:00:00') pasti akan memberikan hasil > yang sama. > atau bisa gunakan TO_DATE(). > > silahkan googling untuk sample querynya. > Hope this may help. > > > -Marthen > -- ============================== Thanks & Best Regards Harry Christian YM : callme_harry G Talk : [EMAIL PROTECTED] MSN : [EMAIL PROTECTED] Skype : harry_christian Friendster : http://www.friendster.com/addfriendrequest.php?uid=5590705 Blog : http://www.harry-christian.blogspot.com =============================== -- www.itcenter.or.id - Komunitas Teknologi Informasi Indonesia Gabung, Keluar, Mode Kirim : [EMAIL PROTECTED] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ITCENTER/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/ITCENTER/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
