Dear Experts,
I have been using Derby DB in a Java
desktop application. I have one database table which is updated explictly via
different information resources as follows:
[Date: DATETIME Stamp] [Amount 1: int]
[Amount 2: int]
2009-01-21 16:01:00.000 61 23
2009-01-21 17:01:00.000 70 25
...
2009-02-12 07:03:00.000 94 31
2009-02-12 07:04:00.000 64 55
2009-02-12 07:11:00.000 74 32
...
I'd ask you, how can I create a Derby SQL
statement in order to retrieve DAILY, WEEKLY, MONTHLY,QUARTELY and YEARLY
Date/Data from this hour based DB table?
Thank you in advance.
Best regards,
_________________________________________________________________
Your E-mail and More On-the-Go. Get Windows Live Hotmail Free.
https://signup.live.com/signup.aspx?id=60969
