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 where else, 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:

    
  1. Re: Date fun with MySQL ( "Nitai @ ComputerOil" 2004)
  2. Re: Date fun with MySQL ( Gary Krockover 2004)
  3. Re: Date fun with MySQL ( "Nitai @ ComputerOil" 2004)
  4. Re: Date fun with MySQL ( Gary Krockover 2004)
  5. Re: Date fun with MySQL ( "Nitai @ ComputerOil" 2004)
  6. Re: Date fun with MySQL ( "Sal D'Anna" 2004)
  7. Re: Date fun with MySQL ( "Nitai @ ComputerOil" 2004)
  8. Re: Date fun with MySQL ( "Sal D'Anna" 2004)
  9. Re: Date fun with MySQL ( "Nitai @ ComputerOil" 2004)
  10. Re: Date fun with MySQL ( "Nitai @ ComputerOil" 2004)
  11. Re: Date fun with MySQL ( "Sal D'Anna" 2004)
  12. Re: Date fun with MySQL ( "Nitai @ ComputerOil" 2004)
  13. Re: Date fun with MySQL ( eLists 2004)
  14. Re: Date fun with MySQL ( "Nitai @ ComputerOil" 2004)
  15. Re: Date fun with MySQL ( Alain Russell 2004)
  16. Re: Date fun with MySQL ( "Nitai @ ComputerOil" 2004)
  17. Date fun with MySQL ( "Nitai @ ComputerOil" 2004)
Hi guys, No one working with MySQL and WebDNA? I can't ask that question no where else, 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)