Hi
Thank you for reading my post.
I have a timeStamp field in a table in derby.
so all my records has a timestamp field.

*how i can select only a restricted records which are in an specific priod of time*
for example records that thier timeStamp are between last 30 days ?
is it possible to use CURRENT_DATE ?

How i can get count of all records that their timeStamp is in same day.
for example if i restric the date in a priod of 30 days i should be able to return 30 integer number which any of them represent total timeStamp which thier day field is one day.



Reply via email to