OraFAQ Forum: Forms » how to add the hrs at the end of each month?

Home » Developer & Programmer » Forms » how to add the hrs at the end of each month?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to add the hrs at the end of each month? [message #86411]

Tue, 28 September 2004 05:11

eboy
Messages: 17
Registered: August 2004

Junior Member

hai

below are my records which already in the database

end_am is varchar2

- date -
- end_am -

- 01-sep-2004 -
- 07:45:00 -

- 02-sep-2004 -
- 08:00:15 -

- 03-sep-2004 -
- 15:30:00 -

- 04-sep-2004 -
- 16:30:30 -

- 05-sep-2004 -
- 11:30:20 -

- 01-oct-2004 -
- 12:15:15 -

- 03-oct-2004 -
- 10:30:16 -

- 05-oct-2004 -
- 14:55:00 -

- 29-oct-2004 -
- 17:20:25 -

i want to produce a monthly report by the end of each month.

when i run my report, it add all the Hours from september to october. let say i want to add for september only not include october. how to do that?

i'm newbies at report

sorry f my example canot be understood

regards

eboy

�

Report message to a moderator

Previous Topic:	calling browser from the form
Next Topic:	help me in transfer data from forms to xls

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Sep 17 18:04:45 CDT 2024