Home » SQL & PL/SQL » SQL & PL/SQL » date time in Sql
date time in Sql [message #19784] Tue, 09 April 2002 15:11 Go to next message
Michael N
Messages: 1
Registered: April 2002
Junior Member
I want to get the total hours for each month. I also want to separate the total hours into two category: 1. between the hours of 6am to 6 pm from monday to Friday.
2. between 6:01 p.m. to 6:00 a.m from Monday thru Firday and the weekend.

Please can anyone help me and thank you in advance...
Re: date time in Sql [message #19816 is a reply to message #19784] Wed, 10 April 2002 22:16 Go to previous message
Alpesh Kothari
Messages: 7
Registered: April 2002
Junior Member
By using this logic u will get hrs of the current month
if u want every months hrs then write a procedure for that

to_number(to_char(last_day(sysdate),'DD')) * 24
Previous Topic: How can I get Leap Year
Next Topic: ORA-01036: illegal variable name/number
Goto Forum:
  


Current Time: Thu Mar 28 16:07:07 CDT 2024