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


ADVERTISEMENT

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

Time Calculation :: Difference Between Login And Current Time

I would like to display the difference between the logging time
[Session("start"] and the current time [now]. In hours minutes and seconds,
I have tried a couple of things but all I see is gobbledy gook.

View Replies View Related

Comparing Current Time To Times Set In Array

basically what i'm trying to do is find the closest time (which are linked) to the current time (which is in red) and then forward a customer to the url.

the linked times are populated from an array, so i think one method would be to sort the array in time order then forward the customer to the first link it finds in the array.

I have no idea how to do this by the way as there doesn't appear to be a sort function in ASP does anyone have any ideas on any ways I could achieve this?

View Replies View Related

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

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

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 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

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

Recordset To Only Contain Current Items (i.e. If Date Of Item Is Past Current Date)

I have a noticeboard that the user inputs items into. One of those is the date of an event. Once that event has passed I want it to disappear from the page.

So I need to do a comparison with current date to the date in the "datestarted" field. My table is called "notices." Using Access and ASP VBscript.

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

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

ASP To Re-load Page From Time To Time To Reset Varaibles

I have a website that I subscribe to that allows me to track tasks. I have an extra computer with a big monitor that i want to always display the task list. the problem is after so many hours I get logged out.

I need to need to reload that sign in url every few hours Code:

View Replies View Related

Comapring Database Time And Computer Date/time

there i was just windering how do i compare a date/time vlaue in sql server agaisnt the computers' date/time.
for example, if computer date/time is two months or 2 weeks before the database date/time do something

View Replies View Related

Time/Date Format And Changing Time To GMT

Currently working on a ASP for a friend, which requires the date and
time on it. It pulls in entries from an Access Database with dates and
times in the format of:

"Fri Oct 17 18:02:46 2003"
However my date and time on the ASP page is displayed as:
"Friday, October 17, 2003 18:02:46"
using the script:
"<%Session.LCID = 1033%>
<%=FormatDateTime(Date(), vbLongDate)%>
<%Session.LCID = 2057%>
<%=time()%>"

Anyone know how to change this script, fully or partly to produce the
date and time on the format that's in the access database i.e. "Fri Oct 17
18:02:46 2003" Code:

View Replies View Related

Time Convert String To OdbcType.Time

I am working on a database that collects information about incidents. One of the fields that people enter is the time of the incident. I am trying to convert that string that people enter into a OdbcType.Time and I am at a lost.

View Replies View Related

Local Machine Time To Eastern Time

How will we convert the system date & time to other timezone for eg: Eastern Time zone using ASP?

View Replies View Related

Time Function Returns Wrong Time

When the Form is submitted I use the Date() and Time() functions to put the date and time into the Body part of the e-mail. The time reported is three hours earlier than the time at which the Form is actually submitted.

I understand these functions are evaluated on the server so the server must be in a time zone three hours earlier than where I am . Is there any way I can get the local time at the location where the user is actually located. ?

View Replies View Related

How To Get Asp Execution Time And Database Connection Time ?

Any some tools or sample codes drop down asp script execute time and
database connection time ?

View Replies View Related

Server Time Local Time Convert

I'm trying to do a very simple code that converts the server time into a time zone of your choice.

<%
dim h 'Current Hour
dim i ' Time Zone Increase - add or subtract hours
dim r 'Result Here
h = Hour(Now)
i = + 2
r = h + i
%>

but obvisouly i'm having trouble with the time zone convert.

View Replies View Related

Compare The NOW Time With A Deadline Time

I am trying to compare the NOW time with a "deadline" time. Please help. Just not sure why this is not working. I need to be able to say IF IT'S BEFORE 9:30 TODAY, IT'S OKAY TO ADD SOMETHING. IF IT'S AFTER 9:30 TODAY, YOU MUST ADD IT TOMORROW.

CODE:

nowtime=now()
deadlinetime=formatdatetime(now(),2) + " 8:30:00 AM"
response.write "NOW: " & nowtime & "<BR>"
response.write "Deadline: " & deadlinetime & "<BR>"
if nowtime<deadlinetime then response.write "can send out today" end if
if nowtime>deadlinetime then response.write "must send out tomorrow" end
if

RESULTS:
NOW: 1/18/2007 8:51:43 AM
Deadline: 1/18/2007 8:30:00 AM
can send out today

As you can see, NOW is GREATER THAN Deadline, so it should must send out tomorrow.

View Replies View Related

Time Calculation :: Between Two Dates And Time

i want to calculate the total time between to dates and time.

Example: Total time elapsed from date 1 time 1 to date 2 time 2.

27/09/2004 11:00 - 28/09/2004 10:30

The user enters a record and then later comes back and closes it. I need to know the time it took from when they entered the record until the time it was closed.

View Replies View Related

Get Current Url

Im trying to get the current url where the user is at and store it into a variable. I want this to be done automatically, not when a user clicks a button. Any ideas?

View Replies View Related

Getting Current URL

a way to get the current URL AND the variables in it, all in one command? There probably isn't, seems to simple, right?

View Replies View Related

Display The Current URL

I'd like to know how to display the current URL on the web page as a footer. This seems to be a fairly simple task, but everything i've found on the internet either doesn't work for some reason, or is asp.net specific....

View Replies View Related

Read Current Url

Is there a way that I can read the current url.

I have an asp page currently such as default.asp?x=1&y=2&z=3

Now I want to keep the existing parameters and attach another parameter
to it and resend to default.asp

As the original parameters are dynamic, and may or may not be
generated, the only way is to read the current url and to simply add my
new parameter such as h=5 to the url.

I don't know how to read the current url.

I tried Request.ServerVariables("SCRIPT_NAME") but that didn't include
the parameters. i.e. it just returned the default.asp

View Replies View Related

Current Connection

Does anyone know where I can find information about Reading current
connection value from performance counters into ASP page. I wanted to
know how I can call the current connection value in my ASP page

View Replies View Related

Current Page

how to print or get the name of current page using ASP

View Replies View Related







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