calculating unique time
This WebDNA talk-list message is from 1998
It keeps the original formatting.
numero = 18232
interpreted = N
texte = That is not the problem we originally talked about, therefore the new subject.At 13:01 Uhr 13.06.1998, bob wrote:You set the login time of a user like this:>logintime=[math]{{[time]}+{00:20:00}}+{[date]}[/math]Hmm... I don't think this will be reliable under any circumstances:[math]{date}[/math] returns the number of days since 00/00/000.[math]{time}[/math] returns the seconds since midnight.If you just add the two values, the result will merely depend on theseconds since midnight:Assume we have 729918 days and 64255 seconds now, we get729918 days + 64255 seconds = 794173Tomorrow we have 729919 days and let's say 20000 seconds:729919 days + 20000 seconds = 749919Effect: the time of tomorrow is older than the value of today! In factany hit tomorrow which occures before the corresponding today's time willbe lower - that is important if the user works around midnight...And here a never-can-be-example ;-)a user logs in today:729918 days + 64255 seconds = 794173and tomorrow, one second before he did today:729919 days + 64254 seconds = 794173Effect: the two results are identical, but there is actually one daydifference!Since WebCat has no (short) function to calculate seconds since the date00/00/0000, I do some sort of digit-shift to get reliable values:> currenthit=[math]{[date]}[/math]*100000> +[math]{[time]}[/math][/math](In clear text: days * 100000 + seconds)For example, a login today:729918 * 100000 = 72991800000 + 64255 = 729918064255and a login tomorrow, same time:729919 * 100000 = 72991900000 + 64255 = 729919064255Effect: tomorrows value is always higher than today's.Peter__________________________________________Peter Ostry - po@ostry.com - www.ostry.comOstry & Partner - Ostry Internet SolutionsAuhofstrasse 29 A-1130 Vienna Austriafon ++43-1-8777454 fax ++43-1-8777454-21
Associated Messages, from the most recent to the oldest:
That is not the problem we originally talked about, therefore the new subject.At 13:01 Uhr 13.06.1998, bob wrote:You set the login time of a user like this:>logintime=
[math]{{
[time]}+{00:20:00}}+{
[date]}[/math]Hmm... I don't think this will be reliable under any circumstances:
[math]{date}[/math] returns the number of days since 00/00/000.
[math]{time}[/math] returns the seconds since midnight.If you just add the two values, the result will merely depend on theseconds since midnight:Assume we have 729918 days and 64255 seconds now, we get729918 days + 64255 seconds = 794173Tomorrow we have 729919 days and let's say 20000 seconds:729919 days + 20000 seconds = 749919Effect: the time of tomorrow is older than the value of today! In factany hit tomorrow which occures before the corresponding today's time willbe lower - that is important if the user works around midnight...And here a never-can-be-example ;-)a user logs in today:729918 days + 64255 seconds = 794173and tomorrow, one second before he did today:729919 days + 64254 seconds = 794173Effect: the two results are identical, but there is actually one daydifference!Since WebCat has no (short) function to calculate seconds since the date00/00/0000, I do some sort of digit-shift to get reliable values:> currenthit=
[math]{
[date]}[/math]*100000> +
[math]{
[time]}[/math][/math](In clear text: days * 100000 + seconds)For example, a login today:729918 * 100000 = 72991800000 + 64255 = 729918064255and a login tomorrow, same time:729919 * 100000 = 72991900000 + 64255 = 729919064255Effect: tomorrows value is always higher than today's.Peter__________________________________________Peter Ostry - po@ostry.com - www.ostry.comOstry & Partner - Ostry Internet SolutionsAuhofstrasse 29 A-1130 Vienna Austriafon ++43-1-8777454 fax ++43-1-8777454-21
Peter Ostry
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
strange [date] behavior (2001)
[WebDNA] Problem with Sendmail (2012)
Problems with dbcatalog.exe (1997)
how realize an advertiser ? (2005)
WC Database Format (1997)
Shopping Cart Problem (1998)
NT 4.0/IIS WebCat Installation (1998)
[AppendFile] problem (WebCat2b13 Mac .acgi) (1997)
Search in 2 or more catalogs (1997)
webcat and OS 8 (1997)
Pull Down Search (2000)
form data submission get (1997)
problems with 2 tags (1997)
OK, here goes... (1997)
Emailer choke (1997)
math with multiple [founditems] (1999)
For those of you not on the WebCatalog Beta... (1997)
Quitting WebMerchant ? (1997)
WebCat B13 Mac CGI -- Frames question (1997)
Cart Numbers (1997)