users@glassfish.java.net

sql query using timer function

From: <glassfish_at_javadesktop.org>
Date: Mon, 05 Apr 2010 23:49:11 PDT

hi friends,

I need to write a query with following condition:
1.The query should display set of records which are posted in the last 24hrs, and it should not display a record which crossed the time limit of 24hrs. In other words a record that is inserted should be visible only for 24hrs from the minute of inserting that record. And after 24 hrs the query should not display the specific record in the output. It should be removed from the output.

thanks in advance
alesa
[Message sent by forum member 'alesa_bdm']

http://forums.java.net/jive/thread.jspa?messageID=395425