Re: Date fun with MySQL
This WebDNA talk-list message is from 2004
It keeps the original formatting.
numero = 58462
interpreted = N
texte = Hi guys,No one working with MySQL and WebDNA? I can't ask that question no whereelse, since no one knnows WebDNA ..........Nitai> From: "Nitai @ ComputerOil"
> Reply-To: WebDNA Talk > Date: Wed, 16 Jun 2004 21:05:30 +0200> To: WebDNA Talk > Subject: Date fun with MySQL>=20> Hi all,>=20> Running a test system here with the native MySQL support of WebDNA and go=t a> question about how dates should be stored.>=20> The best practice so far for WebDNA solutions were to store dates a numbe=rs> like [math]{[date]}[/math].>=20> Should we do the same with MySQL db's and could other systems read that?>=20> We have some fields in our tables that have the fieldtype "date" and of> course MySQL stores them as year-month-date. Returning those fields gives= me> the correct values, but trying to convert those date fields into European> format does not work. Also using the [field> seek=3Dnamed:mydate&get=3Dvalue&raw=3DT] returns me the date as set in the WebD=NA> preferences.>=20> Appreciate any advices.>=20> Nitai>=20> --=20> Tools to energize your business> Web Content Management =ABRedakto=BB & eBusiness Systems>=20> ComputerOil=AE AG> Dammstrasse 7> 5400 Baden / Switzerland> Telefon +41 (0)844 44 55 66>=20> info@computeroil.com> http://computeroil.com>=20>=20>=20>=20> -------------------------------------------------------------> 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/>=20-------------------------------------------------------------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 guys,No one working with MySQL and WebDNA? I can't ask that question no whereelse, since no one knnows WebDNA ..........Nitai> From: "Nitai @ ComputerOil" > Reply-To: WebDNA Talk > Date: Wed, 16 Jun 2004 21:05:30 +0200> To: WebDNA Talk > Subject: Date fun with MySQL>=20> Hi all,>=20> Running a test system here with the native MySQL support of WebDNA and go=t a> question about how dates should be stored.>=20> The best practice so far for WebDNA solutions were to store dates a numbe=rs> like [math]{[date]}[/math].>=20> Should we do the same with MySQL db's and could other systems read that?>=20> We have some fields in our tables that have the fieldtype "date" and of> course MySQL stores them as year-month-date. Returning those fields gives= me> the correct values, but trying to convert those date fields into European> format does not work. Also using the [field> seek=3Dnamed:mydate&get=3Dvalue&raw=3DT] returns me the date as set in the WebD=NA> preferences.>=20> Appreciate any advices.>=20> Nitai>=20> --=20> Tools to energize your business> Web Content Management =ABRedakto=BB & eBusiness Systems>=20> ComputerOil=AE AG> Dammstrasse 7> 5400 Baden / Switzerland> Telefon +41 (0)844 44 55 66>=20> info@computeroil.com> http://computeroil.com>=20>=20>=20>=20> -------------------------------------------------------------> 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/>=20-------------------------------------------------------------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:
WebCat2b15MacPlugin - [protect] (1997)
Browser frames and URLs in the Location field (2004)
[WebDNA] [OT] - One Man. One Road. (2009)
WebCatalog2 Feature Feedback (1996)
Help! WebCat2 bug (1997)
verify online (1997)
sendmail spaces (1997)
E-Commerce site for Canadian and US customers (1998)
Unceremonious Unwanted Unsubscription (1999)
WebCat2b13MacPlugIn - [showif][search][/showif] (1997)
Sorting by SKU Not Working (1998)
can include param variables be valid [math] players? (2000)
FW: 2.01 upgrade problems (1997)
WebCat2 Append problem (B14Macacgi) (1997)
Loosing Quantity (2000)
Alternating BGColors in Table Rows (1998)
I give up!! (1997)
WriteFile and returns... (2000)
Protect and Serve (1999)
Upgrading old WebCat Database Files (1997)