Select col1, col2, to_char(columntanggal,'hh') >From tabelA Group by to_char(columntanggal,'hh')
--nyari data yg jam 9 Select col1,col2 >From tabelB Where to_char(columntanggal,'hh') = '9'; Cmiiw. Maapkeun klo ada yg salah. -----Original Message----- From: "boss_ayi" <[email protected]> Date: Fri, 06 Mar 2009 09:35:51 To: <[email protected]> Subject: [indo-oracle] Menampilkan data berdasarkan Jam 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]
