pakai query spt ini saja

select * from pegawai

where birth_date > sysdate - to_dsinterval(:as_test)

dimana as_test bernilai jumlah hari yang diinginkan dgn format (dd
00:00:00), dd diisi jumlah harinya.





salam



Sofyan B



  -----Original Message-----
  From: [email protected] [mailto:[EMAIL PROTECTED]
Behalf Of Unang Zulkarnain
  Sent: Thursday, October 09, 2008 10:13 AM
  To: [email protected]
  Subject: [indo-oracle] QUERY ULTAH


  Hallo Master2, Suhu, dan Para Punggawa,

  Ada Yang tahu ga query cara mendapatkan ultah hari ini, minggu ini, minggu
  depan, bulan ini, dan custom, misalkan untuk 3 hari kedepan.
  Please help me para master, proyeknya jadi oracel (Ora Celar2).

  Thanks.

  [Non-text portions of this message have been removed]



  


[Non-text portions of this message have been removed]

Kirim email ke