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
asnmurthy
Greenhorn
Joined: Aug 01, 2000
Posts: 7
posted
0
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
Thanks & Regards,<br />Murthy
Surya Bahadur
Ranch Hand
Joined: Sep 28, 2000
Posts: 88
posted
0
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
amit malhotra
Ranch Hand
Joined: Aug 06, 2001
Posts: 30
posted
0
thanx a lot for the reply i hope it works.....
I agree. Here's the link: http://ej-technologies/jprofiler - if it wasn't for jprofiler, we would need to
run our stuff on 16 servers instead of 3.
0
Murthy