Mas Yulius silahkan gunakan fungsi oracle trunc(tanggal)+1 Txs ivan
________________________________ From: Yulius Wibowo <[email protected]> To: [email protected] Sent: Friday, May 8, 2009 1:42:16 PM Subject: [indo-oracle] Re: DateAdd pada Oracle Utk menambahkan 1 hari dari tgl tertentu: 1. select to_date(Tanggal, 'YYYYMMDD HH24:MI') + 1 .... atau 2. select to_date(Tanggal, 'YYYYMMDD HH24:MI') + INTERVAL '1' DAY ... bw --- In indo-oracle@ yahoogroups. com, Bobotoh Milan <gugu...@... > wrote: > > Saya orang baru di dunia Oracle, > Saya mencoba menggunakan fungsi DateAdd yg biasa saya gunakan di SQL Server, > tapi ketika query dibawah saya coba. selalu tampil pesan > "DATEADD". Invalid Identifier > > > SELECT to_char(DateAdd ('H',1, to_date(Tanggal, 'YYYYMMDD > HH24:MI'),'YYYYMMDD HH24:MI')) DATETIME, Judul, HargaJual > FROM M_BUKU > WHERE Tanggal BETWEEN TO_DATE('2009- 04-30 00:00','YYYY- MM-DD HH24:MI') > AND TO_DATE('2009- 04-30 23:00','YYYY- MM-DD HH24:MI') > Group By TO_CHAR(DateAdd ('H',1, to_date(anggalT, 'YYYYMMDD > HH24:MI'),'YYYYMMDD HH24:MI')), > Judul, HargaJual; > > Mudah2an ada teman2 yg kasih pencerahan. > > Wassalam, > Kaka Gugun > > > > -- > bobotohmilan. blogspot. com > > > [Non-text portions of this message have been removed] > [Non-text portions of this message have been removed]
