Re: Date fun with MySQL

This WebDNA talk-list message is from

2004


It keeps the original formatting.
numero = 58465
interpreted = N
texte = Alain my man:-) I figured that saving them in native format will keep the DB save for other applications. But what about if we need to show them in other formats. Each of my hosts want to have different date formats. No I am not using sandboxes :-) Is there any way to achieve this, like the good old [format] tag with MySql date fields? Nitai -- Redakto - Content Management that simply works Content Management & eBusiness Systems ComputerOil=AE AG Dammstrasse 7 5400 Baden / Switzerland Telefon +41 (0)844 44 55 66 info@computeroil.com http://computeroil.com > From: Alain Russell > Reply-To: WebDNA Talk > Date: Thu, 17 Jun 2004 21:28:15 +1200 > To: WebDNA Talk > Subject: Re: Date fun with MySQL >=20 > I'd save them in native MySQL Date format. >=20 > They will then be fast for searching and I'm guessing at a later date > SMSI will add a function to read/change dates from MySQL format to > WebDNA format as an option. >=20 > As well you will be able to access the database with other applications > (PHP) that will not need to many workarounds to read/write the date. >=20 > Alain >=20 > On 17/06/2004, at 5:53 PM, Nitai @ ComputerOil wrote: >=20 >> Hi guys, >>=20 >> No one working with MySQL and WebDNA? I can't ask that question no >> where >> else, since no one knnows WebDNA .......... >>=20 >> Nitai >=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)
Alain my man:-) I figured that saving them in native format will keep the DB save for other applications. But what about if we need to show them in other formats. Each of my hosts want to have different date formats. No I am not using sandboxes :-) Is there any way to achieve this, like the good old [format] tag with MySql date fields? Nitai -- Redakto - Content Management that simply works Content Management & eBusiness Systems ComputerOil=AE AG Dammstrasse 7 5400 Baden / Switzerland Telefon +41 (0)844 44 55 66 info@computeroil.com http://computeroil.com > From: Alain Russell > Reply-To: WebDNA Talk > Date: Thu, 17 Jun 2004 21:28:15 +1200 > To: WebDNA Talk > Subject: Re: Date fun with MySQL >=20 > I'd save them in native MySQL Date format. >=20 > They will then be fast for searching and I'm guessing at a later date > SMSI will add a function to read/change dates from MySQL format to > WebDNA format as an option. >=20 > As well you will be able to access the database with other applications > (PHP) that will not need to many workarounds to read/write the date. >=20 > Alain >=20 > On 17/06/2004, at 5:53 PM, Nitai @ ComputerOil wrote: >=20 >> Hi guys, >>=20 >> No one working with MySQL and WebDNA? I can't ask that question no >> where >> else, since no one knnows WebDNA .......... >>=20 >> Nitai >=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:

Shopping Cart Problem (1998) Trouble with formula.db (1997) WC1.6 to WC2 date formatting (1997) no global [username] or [password] displayed ... (1997) List Name Change Update (2002) Problem about [CART] number (1998) Cart Numbers (1997) Database Structure? (1998) Buying sans cart (1997) Help name our technology! I found it (1997) Paymethod question (1999) [ShowIf] and empty fields (1997) Re2: frames & carts (1997) Criticism of WebCatalog: Keep It Coming! (1998) WebCat2b15MacPlugin - showing [math] (1997) Emailer [cart] file names (1997) simple answer? [hideif] (1997) Download URL & access on the fly ? (1997) Secure server question (1997) Size limit for tmpl editor ? (1997)