What's your actual question? The solution looks as easy as "creationDate BETWEEN ? AND ?", and using e. g. new Date() etc. for date calculations.
> -----Original Message-----
> From: glassfish_at_javadesktop.org [mailto:glassfish_at_javadesktop.org]
> Sent: Dienstag, 6. April 2010 08:49
> To: users_at_glassfish.dev.java.net
> Subject: sql query using timer function
>
> 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
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe_at_glassfish.dev.java.net
> For additional commands, e-mail: users-help_at_glassfish.dev.java.net