mungkin aku tambahkan sedikit nih Select To_Number(to_char(SYSDATE, 'HH24')) From Dual
select * from nama_table where To_Number(To_Char(SysDate, 'HH24'))=4 select * from nama_table where To_Number(To_Char(Tanggal, 'HH24')) Between 1 And 20 ________________________________ Dari: didik prianto <[email protected]> Kepada: [email protected] Terkirim: Jumat, 6 Maret, 2009 19:51:03 Topik: Re: [indo-oracle] Re: Menampilkan data berdasarkan Jam 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 <dollysh...@yahoo. co.id> wrote: From: dollyshaka <dollysh...@yahoo. co.id> Subject: [indo-oracle] Re: Menampilkan data berdasarkan Jam To: indo-oracle@ yahoogroups. com 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] Berbagi video sambil chatting dengan teman di Messenger. Sekarang bisa dengan Yahoo! Messenger baru. http://id.messenger.yahoo.com [Non-text portions of this message have been removed]
