mungkin bisa pakai : select * from nama_table where to_char(SYSDATE,'HH')='4' --ngambil data yang jam 4
lebih jelas bisa liat di : http://www.psoug.org/reference/date_func.html best regards, didik prianto --- On Fri, 3/6/09, dollyshaka <[email protected]> wrote: From: dollyshaka <[email protected]> Subject: [indo-oracle] Re: Menampilkan data berdasarkan Jam To: [email protected] Date: Friday, March 6, 2009, 5:01 AM 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??? > [Non-text portions of this message have been removed]
