Hello Friends, i am developing an application where we have a front end form with button Birthdays Today written on it .When any user clicks the button he is able to view the people in our department having their birthday on current day,I have a backend database in oracle with birth dates stored in it,how can i write a code for the same,the birthdates are in the format yyyy.mm.dd(ex:1975.10.13).please could some one tell me. Thanx
Yeah you can do this by formatting the date like this. select * from your_table_name where birth_date = to_char(sysdate,'yyyy.mm.dd'); Hope this works fine for your query. Thanks & Regards, Murthy A.Murthy@gecapital.com ------------------ Thanks & Regards, Murthy
Hi Try using SimpleDateFormat in the Java class so that your query works even when you switch the database from Oracle to Say DB2.If you are sure that you are going to use only oracle the previous answer by asnmurthy would be fine. Surya