Re: Date+time
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 59497
interpreted = N
texte = I did a login system like that - stored the time as a number on the right of a decimal point which gave a nice delimiter. so it was xxxxx.yyyyyy where xxx is the date as a number and yyy was the time as a number. This also makes it easier to check for a session time out as you can do simple math to compare. Be aware that you need to pad the time value to be the proper number of charactors. I should have some code at home, but out of reach at the moment. Dale Aaron Lynch wrote: > I need to store date and time in one field as a number, and then be able to > extract the date and time back from the number, similar to unix epoch time. > > Looking through the archives, I know this subject has come up a lot, but I > just can't seem to find a working way to do it. Does somebody have any > example of how to do it? > > ------------------------------------------------------------- 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:
I did a login system like that - stored the time as a number on the right of a decimal point which gave a nice delimiter. so it was xxxxx.yyyyyy where xxx is the date as a number and yyy was the time as a number. This also makes it easier to check for a session time out as you can do simple math to compare. Be aware that you need to pad the time value to be the proper number of charactors. I should have some code at home, but out of reach at the moment. Dale Aaron Lynch wrote: > I need to store date and time in one field as a number, and then be able to > extract the date and time back from the number, similar to unix epoch time. > > Looking through the archives, I know this subject has come up a lot, but I > just can't seem to find a working way to do it. Does somebody have any > example of how to do it? > > ------------------------------------------------------------- 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/
eLists
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:
Separate SSL Server (1997)
Email template names (1997)
Hiring: Web programmer in Seattle area (2000)
Summing fields (1997)
Nested tags count question (1997)
Wireless WebDNA available today! (2000)
Expert tech support -- a fast and simple solution (long) ... (2000)
Cookies and webcat (1997)
$adminput doesn't allow [include] files (1997)
[OT] Google Info (2004)
Separate SSL Server (1997)
form data submission gets truncated (1997)
payflow pro on OSX, anyone? (2002)
Shipping Formula % (2003)
webcat nt (1997)
Re:2nd WebCatalog2 Feature Request (1996)
remotely add + sign (1997)
HELP WITH DATES (1997)
Math with Time (1997)
Multi-Row Tables from a search. (1997)