Re: Date Search
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 55361
interpreted = N
texte = Jesse, I know I'm oversimplifying this, but my first-thing-in-the-morning, barely-got-a-gulp-of-coffee-down-my-throat take on this would be to convert the date as it is to something like [seconds_since_epoch] (or some other benchmark that you prefer) and then subtract 30 minutes worth of seconds from it, all on the fly of course. -Dan On Fri, 9 Jan 2004 07:40:01 -0800 Jesse Proudman
wrote: > >On Jan 9, 2004, at 1:13 AM, Kenneth Grome wrote: > >>>I've got a database with the dates and times of accesses on a site. I >>>want to do a search to show all the access on the site in the last 30 >>>minutes, regardless of the time of day. The following search breaks >>>between 12:00 am and 12:30 am.... Ideas? >> >> >>Can't tell anything from your code because all the important stuff is >>in the include files, but it's clear that it's breaking because the >>day has changed, which means your code is apparently not compensating >>as it should.= > >Like I said, the include files are pretty basic, but here ya go: > >newuserhours is a text variable set in a header. It's current value is: 00:30:00 > >timeoffset.inc: > >[math time&show=f]GMT={[date %X]}-{[newuserhours]}[/math][!] >[/!][math time&show=f]NOW={[date %X]}[/math][!] >[/!][if "[offset]"="[raw][offset][/raw]"][!] >[/!][then][!] >[/!][math show=f]offsettime=0[/math][/then][!] >[/!][else][!] >[/!][math show=f]offsettime=[offset]*60[/math][/else][!] >[/!][/if][!] >[/!][math time&show=f]GMTdate=[GMT]+[offsettime][/math][!] >[/!][Format Seconds_To_Time][GMTdate][/Format] > > >-- > Jesse Williams-Proudman >Blue Box Development :: Custom Web Solutions > +1.206.778.8777 :: jesse@blueboxdev.com > > *Happy Holidays* > > >------------------------------------------------------------- >This message is sent to you because you are subscribed to > the mailing list . >To unsubscribe, E-mail to: >To switch to the DIGEST mode, E-mail to >Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------ http://www.StrongGraphicDesign.com http://www.SearchBoise.com (208) 319-0137 | Toll-free p/f 877-561-1656 ------------------------------------------------------------ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Jesse, I know I'm oversimplifying this, but my first-thing-in-the-morning, barely-got-a-gulp-of-coffee-down-my-throat take on this would be to convert the date as it is to something like [seconds_since_epoch] (or some other benchmark that you prefer) and then subtract 30 minutes worth of seconds from it, all on the fly of course. -Dan On Fri, 9 Jan 2004 07:40:01 -0800 Jesse Proudman wrote: > >On Jan 9, 2004, at 1:13 AM, Kenneth Grome wrote: > >>>I've got a database with the dates and times of accesses on a site. I >>>want to do a search to show all the access on the site in the last 30 >>>minutes, regardless of the time of day. The following search breaks >>>between 12:00 am and 12:30 am.... Ideas? >> >> >>Can't tell anything from your code because all the important stuff is >>in the include files, but it's clear that it's breaking because the >>day has changed, which means your code is apparently not compensating >>as it should.= > >Like I said, the include files are pretty basic, but here ya go: > >newuserhours is a text variable set in a header. It's current value is: 00:30:00 > >timeoffset.inc: > >[math time&show=f]GMT={[date %X]}-{[newuserhours]}[/math][!] >[/!][math time&show=f]NOW={[date %X]}[/math][!] >[/!][if "[offset]"="[raw][offset][/raw]"][!] >[/!][then][!] >[/!][math show=f]offsettime=0[/math][/then][!] >[/!][else][!] >[/!][math show=f]offsettime=[offset]*60[/math][/else][!] >[/!][/if][!] >[/!][math time&show=f]GMTdate=[GMT]+[offsettime][/math][!] >[/!][Format Seconds_To_Time][GMTdate][/Format] > > >-- > Jesse Williams-Proudman >Blue Box Development :: Custom Web Solutions > +1.206.778.8777 :: jesse@blueboxdev.com > > *Happy Holidays* > > >------------------------------------------------------------- >This message is sent to you because you are subscribed to > the mailing list . >To unsubscribe, E-mail to: >To switch to the DIGEST mode, E-mail to >Web Archive of this list is at: http://webdna.smithmicro.com/ ------------------------------------------------------------ http://www.StrongGraphicDesign.com http://www.SearchBoise.com (208) 319-0137 | Toll-free p/f 877-561-1656 ------------------------------------------------------------ ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://webdna.smithmicro.com/
"Dan Strong"
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:
Authenticate (1997)
Comments in db? (1997)
WebDNA Solutions ... sorry! (1997)
all records returned. (1997)
Sorting problem (2002)
Replace context problem ... (1997)
Error & Problem (1997)
Shopping problems with 2.1b3 acgi (1997)
Check if file exists (2000)
[WebDNA] Limts? -and- Hot Merge (2009)
Daze to Dates (1998)
Cancel Subscription (1996)
2.0 Info (1997)
I have observed and I am gone. (1998)
Quitting WebMerchant ? (1997)
POP Mail Server Reseting (1998)
Quitting WebMerchant ? (1997)
Upgrade on MacOSX 3.05 to 3.08 (2000)
error count with $purchase (1997)
Checkboxes to add to cart... (1998)