Date fun with MySQL
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 58447
interpreted = N
texte = Hi all,Running a test system here with the native MySQL support of WebDNA and got =aquestion about how dates should be stored.The best practice so far for WebDNA solutions were to store dates a numberslike [math]{[date]}[/math].Should we do the same with MySQL db's and could other systems read that?We have some fields in our tables that have the fieldtype "date" and ofcourse MySQL stores them as year-month-date. Returning those fields gives m=ethe correct values, but trying to convert those date fields into Europeanformat does not work. Also using the [fieldseek=3Dnamed:mydate&get=3Dvalue&raw=3DT] returns me the date as set in the WebDNApreferences.Appreciate any advices.Nitai--=20Tools to energize your businessWeb Content Management =ABRedakto=BB & eBusiness SystemsComputerOil=AE AGDammstrasse 75400 Baden / SwitzerlandTelefon +41 (0)844 44 55 66info@computeroil.comhttp://computeroil.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://webdna.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Hi all,Running a test system here with the native MySQL support of WebDNA and got =aquestion about how dates should be stored.The best practice so far for WebDNA solutions were to store dates a numberslike [math]{[date]}[/math].Should we do the same with MySQL db's and could other systems read that?We have some fields in our tables that have the fieldtype "date" and ofcourse MySQL stores them as year-month-date. Returning those fields gives m=ethe correct values, but trying to convert those date fields into Europeanformat does not work. Also using the [fieldseek=3Dnamed:mydate&get=3Dvalue&raw=3DT] returns me the date as set in the WebDNApreferences.Appreciate any advices.Nitai--=20Tools to energize your businessWeb Content Management =ABRedakto=BB & eBusiness SystemsComputerOil=AE AGDammstrasse 75400 Baden / SwitzerlandTelefon +41 (0)844 44 55 66info@computeroil.comhttp://computeroil.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://webdna.smithmicro.com/
"Nitai @ ComputerOil"
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:
billing system (2003)
Merging databases (1997)
quitting (1997)
Extra Text Fields (was Another question) (1997)
NT - Thanks and Taxes (1997)
Not really WebCat (1997)
Pass a form (2003)
date pref (1999)
Wierd quantities (2000)
WebCat2 several catalogs? (1997)
emailer (1997)
[carts] and databases (1997)
Date Math bug (1998)
[WebDNA] Webdna and CMS (2012)
Hard Questions ? (1997)
PCS Frames (1997)
Progress !! WAS: Trouble with formula.db (1997)
Mac v. NT (1998)
Cart contains # (2000)
emailer w/F2 (1997)