Re: Dates as 20020902
This WebDNA talk-list message is from 2002
It keeps the original formatting.
numero = 43088
interpreted = N
texte = Good thought.... I did some searching around and it's called seconds since Jan 1. 1970 (or Unix Epoch). I'm pretty sure I can figure out how to use it with webDNA now...- ben-----Original Message----- From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of Brian Fries Sent: Tuesday, September 03, 2002 8:33 PM To: WebCatalog Talk Subject: Re: Dates as 20020902 That looks like the number of (seconds? minutes?) since a particular point in time. If you determine the units and the start date, you can convert it into values usable by WebDNA with the appropriate mathrobatics. I'm not Perl-savvy, but the info should be on the web somewhere, or perhaps one of our local perl-types will chirp in with some details.- brianAt 7:53 PM 9/3/02, Ben Swihart wrote: >Sweet! What about this number: 1030938753 ? > >This is some sort of time stamp, but I can't figure out what. It is >generated by perl. Do you recognize it and if so, how do you propose >breaking it up for use by webDNA? > >Thanks!! > >- Ben > >-----Original Message----- >From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf >Of Brian Fries >Sent: Tuesday, September 03, 2002 7:01 PM >To: WebCatalog Talk >Subject: Re: Dates as 20020902 > > >[text]sqldate=20020902[/text] >[text]tYear=[getchars start=1&end=4][sqldate][/getchars][/text] >[text]tMonth=[getchars start=5&end=6][sqldate][/getchars][/text] >[text]tDay=[getchars start=7&end=8][sqldate][/getchars][/text] > >... then you can recombine [tYear] [tMonth] and [tDay] however you wish > >- brian > >At 4:37 PM 9/3/02, Ben Swihart wrote: >>Can webDNA deal with a date like YYYYMMDD ? This is the standard MySQL >date >>format... is there a way to convert this date to a format that webDNA can >>understand and reformat? >> >>Thanks! >> >>Ben M. Swihart >>Web Designer, SysAdmin : The GoTriCities Network > >ben@gotricities.net------------------------------------------------------------- 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://search.smithmicro.com/ ------------------------------------------------------------- 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://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Good thought.... I did some searching around and it's called seconds since Jan 1. 1970 (or Unix Epoch). I'm pretty sure I can figure out how to use it with webDNA now...- ben-----Original Message----- From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf Of Brian Fries Sent: Tuesday, September 03, 2002 8:33 PM To: WebCatalog Talk Subject: Re: Dates as 20020902 That looks like the number of (seconds? minutes?) since a particular point in time. If you determine the units and the start date, you can convert it into values usable by WebDNA with the appropriate mathrobatics. I'm not Perl-savvy, but the info should be on the web somewhere, or perhaps one of our local perl-types will chirp in with some details.- brianAt 7:53 PM 9/3/02, Ben Swihart wrote: >Sweet! What about this number: 1030938753 ? > >This is some sort of time stamp, but I can't figure out what. It is >generated by perl. Do you recognize it and if so, how do you propose >breaking it up for use by webDNA? > >Thanks!! > >- Ben > >-----Original Message----- >From: WebCatalog Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf >Of Brian Fries >Sent: Tuesday, September 03, 2002 7:01 PM >To: WebCatalog Talk >Subject: Re: Dates as 20020902 > > >[text]sqldate=20020902[/text] >[text]tYear=[getchars start=1&end=4][sqldate][/getchars][/text] >[text]tMonth=[getchars start=5&end=6][sqldate][/getchars][/text] >[text]tDay=[getchars start=7&end=8][sqldate][/getchars][/text] > >... then you can recombine [tYear] [tMonth] and [tDay] however you wish > >- brian > >At 4:37 PM 9/3/02, Ben Swihart wrote: >>Can webDNA deal with a date like YYYYMMDD ? This is the standard MySQL >date >>format... is there a way to convert this date to a format that webDNA can >>understand and reformat? >> >>Thanks! >> >>Ben M. Swihart >>Web Designer, SysAdmin : The GoTriCities Network > >ben@gotricities.net------------------------------------------------------------- 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://search.smithmicro.com/ ------------------------------------------------------------- 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://search.smithmicro.com/
Ben Swihart
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:
[WebDNA] RESTART WebDNA (2016)
Sku numbers (1997)
New WebCatalog Version !!! (1997)
Can't use old cart file (was One more try) (1997)
links page (2002)
Wanted: More Math Functions (or, Can You Solve This?) (1997)
Emailer (1997)
Suggestion: appendfounditems (2002)
Group search doesn't work. (1997)
[WebDNA] CMS in WEBDNA (2009)
RE: Adding a product from another site (1997)
Not really WebCat - need HTML Grider (1997)
Count regular expressions in a file (2007)
BW in a search (2007)
Verifying both name and password (was: New Problem) (1997)
Date problems-more (1997)
totals (1997)
ShowNext for method=POST (1997)
shocart strange behavior - ANSWER (1999)
Timeout question .. (2003)