coba pakai script ini .... .aku sarankan pake to_number aja .... select cust.first_name, cust.last_ name,order. date, order.item_code, order.amount from cust,order where to_number(to_char(order.date, 'YYYYMMDD')) between 19881019 and 19881021;
________________________________ Dari: dollyshaka <[email protected]> Kepada: [email protected] Terkirim: Jumat, 6 Maret, 2009 17:01:54 Topik: [indo-oracle] Re: Menampilkan data berdasarkan Jam select cust.first_name, cust.last_ name,order. date, order.item_code, order.amount from cust,order where order.date in ("19/10/88", "20/10/88" ,"21/10/88" ); untuk lebih jelasnya mending klik http://www.iso. port.ac.uk/ ~mike/docs/ informix/ select.html atau http://www.psoug. org/reference/ select.html karena saya juga baru belajar hehehehe.... --- In indo-oracle@ yahoogroups. com, "boss_ayi" <boss_...@.. .> wrote: > > Gimana caranya nampilin data berdasarkan jam, > saya input waktunya pake sysdate. > trus kalo mau ngambil recordnya berdasarkan jam tertentu querynya gimana ya??? > Kenapa BBM mesti naik? Apakah tidak ada solusi selain itu? Temukan jawabannya di Yahoo! Answers! http://id.answers.yahoo.com [Non-text portions of this message have been removed]
