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:

    
  1. Re: WebCat2 - storing unformatted date data? (Grant Hulbert 1997)
  2. WebCat2 - storing unformatted date data? (Kenneth Grome 1997)
>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:

RE: protect tag on NT (1997) Disconts (2004) Writefile outside WebSTAR hierarchy? (1997) Error.html (1997) Bookmarked URL with cart (1998) Paths, relative paths, webstar server setup and security (Mac) (1997) problems with WebCat-Plugin (1997) Emailer setup (1997) Nesting format tags (1997) Nesting format tags (1997) 2.0Beta Command Ref (can't find this instruction) (1997) Applescript Hack (1996) orderfile and setlineitems (1998) I'm new be kind (1997) Writing encrypted files causes errors ... (1998) Migrating to NT (1997) webcat2b12 CGI -- Date comparisons (1997) How to search dbs across virtual hosts for same domain? (2003) Contribution (2000) [WebDNA] www.webdna.us store down?? (2012)