Average Of The Hours

I need to get average of the hours after (start_date - end_date). *start_date and end_date is in format 'mm/dd/yyyy hh:mi:ss am' . Is there any function in oracle that i can use so that i can directly get the average of the hours in SQL statement?

View Replies


ADVERTISEMENT

12 Hours Format Into 24 Hours

i'm importing a date ( 13/2/2005 1:20:22 PM) from SQL server
to informix.
The problem now is informix doesnt accept alphabet in datetime format,
so i plan to convert it before the date insert into informix db.
But the problem is i dont know any function that can convert the date time
from 12 hours format to 24 hours format.

View Replies View Related

Working Out Average

I have a record set:

Code:

<%= DoDateTime((rsBoxEdit.Fields.Item("").Value), 3, 2057) %>


And it displays data such as:
00:00:36
00:05:05

And i want to work out the average of these numbers in a loop to output a total

View Replies View Related

Getting Average From Records...

I need to get the average figure from a number of records for a user - that is, each user has several "food_records" with a field "Calories"

Dim sql2
sql2 = "SELECT * FROM Food_Records WHERE Member_ID = " & memberid & " AND Date BETWEEN #" & datetoday & "# AND #" & dateLastWeek & "# "

rsRec.open sql2, adoConn

If not rsRec.eof then

calsToCompare = avg(rsRec(3)) 'I KNOW THIS IS NOT HOW TO DO IT!!

So, how can I get the average calorie value for that user for that particular time frame?

View Replies View Related

Group By Average...

I want to Group my records by the average of a field...

I tried using 'GROUP BY AVG(Rating)' but that's an illegal use...

Is there another way, besides opening another recordset? I also used:

... AVG(Rating) as AverageRating GROUP BY AverageRating ...
But, same problem...

View Replies View Related

Average Function

I've looked and can't find a built-in function for ASP that performs averages. If I have a SQL statement that returns thousands of numerical results back to my ASP script, what is the best way to average all of these results?

View Replies View Related

Getting Out The Average Of 3 Numbers.

I have in my database set up 3 fields (num1, num2, num3) and inserted 5 records. How can i get the average of each row out on my homepage?

View Replies View Related

Calculating Average From An Array

I have an array like

array = "1,2,3|,2,4,6| ...)

There will be an unknown number a values between the | and an uknown total number of values. I need to get the average of the number between each of the |'s. Any ideas how to handle that?

View Replies View Related

Gettin Average Of Last 10 Records

I have little golfclub with a leaderboard where each member gets point after each match (1 - 20 points). Is it possible to get the average point of the last 10 records, and what if they only played 7 matches can i get the average of that.

View Replies View Related

Number Into Hours

I need to convert number into hours..Example: 12.60 should be 13 hrs,etc.

My variables
Total = oRs0("Tot") + oRs1("Tot1")

View Replies View Related

Subtracting Hours From 'Now()'

How can I subtract hours from 'Now()'?

I can subtract a day, but that's by only having ONE integer...what do I do for hours? (i need this because our server uses EST and clients need their TimeZone)

View Replies View Related

Add Hours To The Current Time

how you convert an integer such as 5 into an hour string so the system identifies it as an hour instead of just the number 5 and then once you do that ("if you need to do that at all") add 5 hours to the current time...

Also is there a way way to add lets say 50 hours to our current time and date so when it is calculated it shows 2 days and 2 hours away from now... If you cant do that it would be nice to know how to change 7.85 into just 7... or 8.94 into just 8... no rounding up or down just the first number before the decimal.

View Replies View Related

Total Weekly Hours

I am using a select sum(tot_daily) as total hours ...it calculates the time incorretly...
Example:
ID | Tot_hrs | Person
----------------------
1 5.45 A
2 5.45 A
3 5.45 A

The total hours should be 17 hours 15 mins...but the result comes as 16.35.... Is there a way to calculate it as 17.15 in db level in a select statement

View Replies View Related

ASP DATE Between NOW And 24 HOURS Earlier.

How would I write in SQL or ASP the following?:

Count number of Database Records between NOW and 24 HOURS EARLIER? I know
how to retrieve recordsets etc - its just the date thing I cant grasp. I am
stuck getting the 24 hours earlier data capture.

View Replies View Related

Obtaining Work Hours

I have a request from the boss to make a report that will require me to display how many hours something has been in a particular state. (As in status). Hard to explain. Anyway, I need to go to the table in the db, find all rows for a particular trouble ticket, find when they were put into one of our 7 statuses, when they were put into another status (this info is already in those rows), then determine how many hours they spent there in
each status.

So a ticket report will say that ticket 1000 spent 4 hours in customer research, 5 hrs in our company coding. 3 in our company testing, 4 in customer testing, etc.

The thing is, It has to assume an 8-5 workday, and leave out any hours which don't fall in between 8 am to 5 pm, and also rule out any weekends.

View Replies View Related

Date, 12 & 24 Hours Clock Format

I have two Win2K machines. Both "appear" to have been set up identically.

They both reckon that they're using UK date format.

However, if I create the following ASP code:

<%
Response.Write Now
%>

One returns
16/01/2004 17:12:19

Which is what I want, whilst the other returns:

1/16/2004 5:15:21 PM

Here, the day and month have been transposed and the time appears in the 12 hour clock format.

View Replies View Related

If The DateDiff Is 24 Hours, Delete Record

I just need to know the DateDiff function for what I need to do...

I will store the date of the database record in a variable called 'sDate' what now? (Also, the format is xx/xx/xx 2:4:56 PM/AM)

View Replies View Related

Writing Code To Countdown Hours

I'm trying to write a script to countdown the number of hours and minutes until tomorrow. So far, this is what I have:

Code:
<%
response.write(dateDiff("h",now(),date+1)) & " hours and " & dateDiff("m",Time(),date+1) & " Minutes "
%>
The code above correctly displays the hours until tomorrow. but it's not displaying the minutes correctly. It's displaying the total minutes until tomorrow. If there at 4 hours left until tomorrow it's saying "4 Hours and 240 minutes."

I need it to display "4 hours and 0 minutes."

View Replies View Related

Years, Months, Days, Hours, Seconds

Been playing with the function DateDiff, and with it it's easy to calculate the difference in years/months/days between two dates. However, if i wanted to calculate the difference in Years, Months, Days, Hours, Seconds (a la Ebay bids) how can I do this? Is it easy or complicated?

View Replies View Related

Database Current Time -(minus) 3 Hours

Ive got some code on my site that shows how current the database is. Basically it looks at fixed text file that I am basing the database on, checks to see iwhen it was created, then displays the time.

My webserver must be on the East Coast and I am on the West Coast, so the time the stamped file time is 3 hours ahead. Code:

View Replies View Related

I Just Spent Several Hours Shaving A Total Of 250 Milliseconds Off My Application

building variable width/DB tables etc using getrows instead of movenext.
Performance is a major concern as this app requires SSL.

My question is, when does it become more about the challenge of building
faster apps vs. getting the job done??? If my calculations are correct, I
just added an extra 10,000+ possible hits within a 12 hour day or so.. an
extra 10,000 hits???!!! What percentage of applications do you think will
ever see this kind of traffic?

Is this insane? If this app ever gets maxed out, will my end users ever
realistically notice a difference?

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved