Re: WebCat2 - storing unformatted date data?
This WebDNA talk-list message is from 1997
It keeps the original formatting.
numero = 10567
interpreted = N
texte = >Is it possible to store the date in a database field without any date >formatting whatsoever? In other words, how do I put the number of seconds >since 01/01/1900 into a database field?It's not a good idea to store that raw number, because we reserve the right to change its meaning at any time (It's already changed once or twice during beta). But if you really want to, then store [convertdate][date][/convertdate] as the value.Grant Hulbert, V.P. Engineering | Tools for WebWarriors Pacific Coast Software | WebCatalog, WebCommerce Solution 11770 Bernardo Plaza Court, #462 | SiteEdit, SiteCheck, PhotoMaster San Diego, CA 92128 | 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com ------------------------------------ To leave this talk list send an email to macjordomo@smithmicro.com with BODY unsubscribe WebDNA-Talk ------------------------------------
Associated Messages, from the most recent to the oldest:
>Is it possible to store the date in a database field without any date >formatting whatsoever? In other words, how do I put the number of seconds >since 01/01/1900 into a database field?It's not a good idea to store that raw number, because we reserve the right to change its meaning at any time (It's already changed once or twice during beta). But if you really want to, then store [convertdate]
[date][/convertdate] as the value.Grant Hulbert, V.P. Engineering | Tools for WebWarriors Pacific Coast Software | WebCatalog, WebCommerce Solution 11770 Bernardo Plaza Court, #462 | SiteEdit, SiteCheck, PhotoMaster San Diego, CA 92128 | 619/675-1106 Fax: 619/675-0372 | http://www.smithmicro.com ------------------------------------ To leave this
Talk List send an email to macjordomo@smithmicro.com with BODY unsubscribe WebDNA-Talk ------------------------------------
Grant Hulbert
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:
Quit revisited (1997)
TCPConnect/TCPSend/FTP syntax (2000)
Multiple catalog databases and showcart (1997)
No. of items in shopping cart (2000)
wish list (2002)
looping table rows (1999)
Showif Error Generated... (2003)
Re[2]: Enhancement Request for WebCatalog-NT (1996)
textarea to page display (1998)
rounding onlu UP (2002)
Re[2]: when is failing to [URL]ize values in a comparison ri (1999)
Help name our technology! (1997)
2nd WebCatalog2 Feature Request (1996)
Format all of a sudden doesn't work (1997)
forming a SKU (1999)
Running 2 two WebCatalog.acgi's (1996)
WebCat2: Items xx to xx shown, etc. (1997)
multiple databases (1997)
How to put the Trademark Symbol (%99) in Sendmail? (2003)
Empty Shopping Carts? (1998)