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")
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.
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 View RelatedSubtracting 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)
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.
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
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.
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.
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.
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)
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."
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 RelatedDatabase 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:
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?
Convert Real Number Into Text Number
I need to insert some number into database as text. My problem is if I insert the number (ie. 4.0), the value in the database only show (4). So, is it possible to convert a real number into text number using ASP?
View Replies View RelatedSequential Number After Batch Number
here is the scenerio
in master batch table i have various master batch like
200701-0001
200701-0002
200701-0003
Now each master batch can have multiple final mixed batch like
200701-0001-01
200701-0001-02
200701-0001-03
and this record is inserted in to fmix table.
so i have a form in which i have a dropdown menu in which all the master batch is listed,
i select 200701-0001 and that value is passed to next page where i will enter other fields data and insertion to my fmix_no will be done automatic like 200701-0001-01, 200701-0001-02 and so on,
how to achieve this
so in short each master batch will have more than one final mixed batch.
pls help, also if u have any online contact in yahoo or msn pls send me, i am so confused and badly struck deadline is just couple of hours away. my yahoo id is(E-Mail address blocked: See forum rules) you can PM me i am online right now.
Retrieve The Error Number In VB With Err.Number
I want To handel the error messages by myself in one part in my script. I know that in VB I can Use the statment - On error resume next And I also know that I can retrive the Error Number In VB with Err.Number.
How can I handel the errors by myself in ASP? I heard about the ASPErr Object, Is it the same thing like the err object in VB?
Number
if I dispaly certain column data from database, how to make the auto numbering in front of each data?for example
1. ha
2. ho
3. hu
let say the ha, ho and hu is data that call from database column.
Whole Number
Can you help me with this? Is there any function that I can use in getting a
whole number
Example:
Input OutPut
12.3 12
1.63 1
21.1 21
Im using the function left(p1,p2) but it doesnt recognize the whole number
Err.number <>0
I have an error statement in place which i would like to catch when a problem aoccures and assign a value to Compensation.
Code:
If Err.number<>0 then
If iCount Mod 2 = 1 Then
objRS.Move ((iCount + 1)*0.9)-1
Compensation = Int(objRS(0))
Else
objRS.Move (iCount*0.9)-1
Compensation = objRS(0)
objRS.MoveNext
Compensation = (Compensation + objRS(0))/2
End If
Else
Compensation = 0
End If
at the moment,Compensation seems to always have the value of 0 even when an error is not evident. Have i got this the wrong way around?
Number
i m getting such number 3001/e-00084308/00/000
so each time i want to change 00 to 01 in above number
Number IP
I want to have the address IP of the client's machine. I have made this.
<b>Your IP address is:</b>
<%Response.Write(Request.ServerVariables("remote_addr"))%>
</p>
but It give me the address of my host I wish I have IP of the machine client.
Avg Number
I am using the code below to count the number of records and divide it by the sum of the records to get the average number. I get the error : Type mismatch: 'ubound' . I know I'm missing something obvious as my experience with arrays have rendered below.
<% PriceArray = Recordset1("TotalBidPrice") %>
<%
for x = 0 to ubound(PriceArray,2)
CountArray = CountArray + PriceArray(0,x)
next
ThePriceAvg = CountArray/(ubound(PriceArray,2) + 1)
%>
<%=ThePriceAvg%>
Not A Number
How do you check if a value is "not a number" in Visual Basic? Ie:
If textbox is not a number then
msgbox "Please enter a valid number"
Else
.............
End If
ID Number
I have a form on my site, in the form there is a field called ticketid, I want this field to be prepopulated everytime the user opens the form, Also would like to have it start with 1000 so if the it gets open second time its 1001, third time 1002 and so on. Code:
View Replies View RelatedNull Number
Microsoft OLE DB Provider for SQL Server (0x80040E2F)
Cannot insert the value NULL into column 'ContactID', table 'ka0506a.ka0506a.contacts'; column does not allow nulls. INSERT fails.
/submitcontact.asp, line 15
What happened is i used to used MS Access and ContactID is an Autonmuber field, and now my connection is set to MS SQL so it's giving me this error, what's causing this error to happen and how can i change it ?
Number In A Repeater
I have a repeater that pulls back informtion from a MySQL database. I was wondering how could I put a counter that increments as each row is returned and displays it in the repeater. For example where it says Day:, I want to make that Day: 1, Day: 2 etc as each row is returned.
The Day: 1++ is just a demonstration of what i want incremented.
<asp:Repeater ID="RepeaterUserReportSummary" runat="server">
<ItemTemplate>
<table style="width: 990px">
<tr>
<td style="width: 185px;height: 10px;"><b>Day: 1++ </b></td>
<td style="width: 35px;height: 10px;"><b>Total:</b><%# Eval("TotalReport")%>cal</td>
</tr>
</table>
</ItemTemplate>
</asp:Repeater>
Number Of Records
Any build in function that can calculate number of records in a table?
View Replies View RelatedHow To Round Up A Whole Number?
I've created a freight calculator that needs to know how many pallets I'm shipping. I'm using 1 pallet for 750lbs and an extra pallet for anything more than that.
If materialWeight <= 750 Then numPallets = 1 Else numPallets = Round(materialWeight / 750) End If
Now, let's say the materialWeight/750 ends up being 3.2. This is returning 3, but I need it to return 4 since we need an extra pallet.
How can I make it Round up to the next whole number? If it turned out to be an exact number without a decimal then it should stay where it is, but if it's over x.0 at all it should go up to the next whole number.
Number Truncation
Is there a command in asp to truncate a decimal? Currently I've got a number that's coming out with up to about 12 decimal places based on input fom the user and I'd like to force it to just display up to two decimal places. Is that possible?
View Replies View RelatedHow Can I Know My IIS Version Number?
I am using w2000+sp4 server with IIS running, how can I know my IIS version
number, is it iis5.0 or 5.1 or 6.0?
I must know this, since I want to download patches from MS web site,
Number Of Bytes
When we are using ENCTYPE="multipart/form-data" for file uploading, we can use Request.TotalBytes to get the total number of bytes sent by the user in http. Is it possible to get the bytes of a specific field from that form
Get Week Number
Does anybody know how I can get the week number. The week number we are currently on is 28 and I need to be able to reitrieve this number so that i can manipulate for loops to advance that number to 33 and 38.
View Replies View Related