i need to get the number of seconds since Jan 1, 1990 or 70 or something to compare session times ... how do i get the timestamp in seconds ...
btw the msdn library is not a very good one ... does any one know an asp manual simillar to php (downloadble) ...
does anyone have any functions that can emulate the timestamp functionality available in PHP? I know this feature is not built in ASP, that's why I was asking for a set of functions that anyone made for emulating this feature. Its quite handy as storing date/time as a timestamp is quite beneficial than just storing it as DD/MM/YYYY HH:MM:SS format.
View Replies View RelatedI've got this timestamp (369318968) that I BELIEVE is generated by an ASP page, possibly an ASP.NET one. I'm not sure though and I don't have access to a server that supports ASP to see if I can generate a timestamp that looks like that, so I'm asking for help here.
Does 369318968 look like a timestamp generated by ASP or ASP.NET? Would it be possible to pass that timestamp to the timestamp functions of ASP to try and get the regular format back?
I have an asp file upload facility on my website and I now want to add a timestamp to the name of each file uploaded to my webserver to ensure no clash of names.
I have no idea how to code it so egfile.txt will arrive on the server as egfileYYYYMMDDhhmmss.txt (or something similar).
Is it possible to do?
I've created a form and I want to add a timestamp to it. How do I do this? I'm using dreamweaver by the way.
View Replies View Relatedhow can i only display the hour / minute portion when i do (timestamp2 - timestamp1) in asp. When i display in asp, it gives me some funky number, probably it is the representation of timestamp value. It works in query analyzer, it gives me some date but the time is write though.
View Replies View RelatedHow would one go about creating a time stamp for a user login session. Currently im using cookies to capture the user id and other related info about the user. How could i create a time stamp within a cookie session at the time of login for a user? And conversly capture the logout time?
View Replies View RelatedMy payment processor requires that I generate a 13 digit time stamp using ASP based on GMT time. What function can I use in ASP to generate this timestamp?
View Replies View RelatedI need to create a timestamp in this format.
Fri, 30 Oct 1998 14:19:41 GMT
im trying to find what code i need to change the user_timestamp field of my database to the correct current server date and time by a SQL query
im trying to use
mySQL = "UPDATE members SET user_timestamp = '(DateAdd(""d"",0,now()))' WHERE Nick = '" & pc_nick & "'"
and it sees the NICK just fine but does not update the timestamp to the current date.
I have a table that has data timestamped (5/3/2006 2:31:00 PM) and need to select data based on the year of the time stamp. Can I do this in the select or do i need to select all and parse thru the timestamp?
View Replies View RelatedCode:
StartTime = FormatDateTime((rs("startdate")),3)
this returns
7/4/2006 1:00:00 AM
I need to trim the seconds off so it looks like this
7/4/2006 1:00 AM
i am trying to display a timestamp value from sql server using asp code but getting type mismatch error, how to display a complete timestamp like 0x000000f0g00 etc.
View Replies View RelatedI am uploading files to my webserver using an asp upload script and would
like to add a timestamp just before they are saved to the server.
This would mean that filename.txt on my server would be uploaded to the
webserver as filenameYYMMDDhhmmss.txt or something similar.
If execute the following sql on my MySQL database -
sqlremove = "UPDATE fib_note SET fib_note_actdone = 1 WHERE fib_note_id = '" &Request("id") &"' "
It seems to also be effecting another field in my table called fib_note_timestamp which is a timestamp data type with a default value of current_timestamp. How come and how can I stop this?
Basically I have 2 times:
timea = (date here) 12:00:00 PM
timeb = now()
and what i want to do is compare the difference in seconds between the two.
But I'm struggling and the thought has crossed my mind that DateDiff only works with dates not times...
Code:
<%
Dim DateToCompareTo
DateToCompareTo = 4/10/2005 1:00:00 PM
%>
There are <%= DateDiff("s", Now(), DateToCompareTo) %> seconds left %>!
I have a variable that returns a certain number of seconds. Is there a function that can format this into something more useful?
For example, if the variable returned is 32, then it would format it to say "32 seconds"
If the variable is 312, then it would return "5 minutes and 12 seconds"
If the variable was 7315 then it would return "2 hours, 1 minute, and 55 seconds"
And so on.
Is there a way to response.redirect to a url within 5 seconds or something, so its not right away? I was thinking meta refresh, but everywhere I go online it says that meta refreshes are not a good idea.
View Replies View RelatedI'm having a problem with this code:
Code:
<input type="hidden" name="lastdate" value="<%=now%>">
not returning the "seconds" portion of time. It writes the date and time - but only to the minute. The seconds are 00 each time. Ex. 1/29/2005 1:47:23 PM is what I want and 1/29/2005 1:47:00 PM is what I'm getting.This is the result I'm getting on two separate DB's on two different servers. I'm sure there's some glaring problem I'm overlooking because I sure can't see it.
I have a column in my Access db that stores a number which is supposed to be seconds. How can I convert the seconds to display mm:ss on my ASP page? For instance, if the number in the db is 300, I want it to display 5:00 on my page.
Now these are lengths of time, not current time (AM or PM), so I dont want it to display the AM or PM. I've tried format(rs("length"), "nn:ss") and that didnt work. Matter of fact Format(), FormatDateTime(), and FormatNumber() doesnt work on my page. I've been getting the 800a000d Type Mismatch error. What am I doing wrong? Code:
I'm trying to set up an asp script that redirects a user after a few seconds on a page- I cant use meta tags to redirect due to the page structure.does anyone have any similar scripts they could share?
What is the best way to do an ASP/sleep for 8 seconds (pause script for 8 seconds)? I have tried the following:
EndTime = Now() + (8 / (24 * 60* 60)) '8 seconds
Do While Now() < EndTime
'Do nothing
Loop
But unfortunately that keeps the CPU at 100% for that time. I need something that doesn't impact the CPU, as this delay will be in a while loop that will execute continuously for a few days.
I'd like to find the time difference in seconds in my ASP-code, but can't find how to do this. In php you have the time() that give the seconds from 1.1.1970 (?) until now. Is there something like this in ASP too? I have found the DateDiff that one just gives days, right? I basicly want to have two variables, time1 and time2, and show the seconds between them.
View Replies View RelatedI have a simple calendar scipt that ask for time of event input. While I like the time feature I do not like the fact that it displays with seconds included.
Ex. Displays HR:MIN:SEC 5:05:30 PM
Desired display 5:05 PM
How do I get rid of the display showing seconds? I have changed the database format, but this does not seem to effect the disply on the asp page.
I need to convert seconds into time since for a message board application.
"minutes ago, hours ago and days ago" etc.
I have capture the time of the original post and compared it to the time now getting seconds but having a little trouble working out the seconds into time. Have used calculations (/60 minute), (/3600 hour), and (/86400 hour) but the time remaining is bugging me.
I currently have entries in my dbase with time stamps. Does anyone know how I would display only those records with the time stamp that reflects a particular day. For example I want to display all records from today which would be 8/23/2004 on the page.
Im assuming this has something to do with the Date () function but i dont understand how it could incorporate it into code.
The code to show how long it took the page to generate in seconds ?!?, if you get onto the main page of this site, www.tgplus.net and loom at the left had side, it tells you how long it took the page 2 generate.
View Replies View RelatedBeen 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 Relatedhow to do the count down timer? which their is count down timer for sepacific day, hour, minute and second.
View Replies View RelatedI need to get the number of seconds when subtracting two date/times.
With the code I am using below I subtract the two date/times and end
up with a total of days like "1.56".
Then when I multiply it to get
the number of seconds I am not getting an accurate number. I should
only have whole numbers of seconds with nothing past the decimal
point. I would like to be able to subtract the two date/times and get
the number of seconds without multiplying to get it. Is this possible?
Does anyone have a better more accurate way to do this? Code: