Re: MySQL Dates and WebDNA
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 61152
interpreted = N
texte = Not that it helps you right now, but we have added a new "ymd=3D" =parameter for the [date] tag. This allows you to input a given date, in =a 'normalized' format, which is then displayed according to your WebDNA =date display prefs. For example:[date ymd=3D2005-12-25]For my settings this displays as 12/25/2005This should also help with 'date' math, when you need to be certain how =a date will be interpreted when it is used as input in an equation.-----Original Message-----From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf OfNitai @ ComputerOilSent: Wednesday, February 23, 2005 08:52 AMTo: WebDNA TalkSubject: MySQL Dates and WebDNAHi allI need a little help with WebDNA and MySQL Dates.We store all dates in the =E2=80=9Cnormal=E2=80=9D MySQL Format that is ==E2=80=9C2005-02-25=E2=80=9D. Now how can we show these dates in =European format?I have no clue, but who wonders after 18 hours of straight =work=E2=80=A6=E2=80=A6TIA for any help.Nitai--Redakto - Content Management that simply worksContent Management & eBusiness Systems=20ComputerOil=C2=AE AGDammstrasse 75400 Baden / SwitzerlandTelefon +41 (0)844 44 55 66=20info@computeroil.comhttp://computeroil.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/-------------------------------------------------------------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:
Not that it helps you right now, but we have added a new "ymd=3D" =parameter for the [date] tag. This allows you to input a given date, in =a 'normalized' format, which is then displayed according to your WebDNA =date display prefs. For example:[date ymd=3D2005-12-25]For my settings this displays as 12/25/2005This should also help with 'date' math, when you need to be certain how =a date will be interpreted when it is used as input in an equation.-----Original Message-----From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Behalf OfNitai @ ComputerOilSent: Wednesday, February 23, 2005 08:52 AMTo: WebDNA TalkSubject: MySQL Dates and WebDNAHi allI need a little help with WebDNA and MySQL Dates.We store all dates in the =E2=80=9Cnormal=E2=80=9D MySQL Format that is ==E2=80=9C2005-02-25=E2=80=9D. Now how can we show these dates in =European format?I have no clue, but who wonders after 18 hours of straight =work=E2=80=A6=E2=80=A6TIA for any help.Nitai--Redakto - Content Management that simply worksContent Management & eBusiness Systems=20ComputerOil=C2=AE AGDammstrasse 75400 Baden / SwitzerlandTelefon +41 (0)844 44 55 66=20info@computeroil.comhttp://computeroil.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/-------------------------------------------------------------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/
"Scott Anderson"
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:
redirect with frames (1997)
06/06/2000 bug warning ... (2000)
Site Check (2006)
Mac: [ListFiles] bug alert (1997)
Date search and sendmail (1997)
Failing Email (2004)
[format 40s]text[/format] doesn't work (1997)
Emailer Set Up (1997)
Forbidden CGI Error (1997)
Secure server question (1997)
Generating Report Totals (1997)
WebCatalog 2.0 & WebDNA docs in HTML ... (1997)
Stymied by [ShowNext] with drop down list on a form (1998)
Unexpected error (1997)
Another bug to squash (WebCat2b13 Mac .acgi) (1997)
showif math date (2002)
Searching multiple Databases (1997)
Preserving form data (1999)
Another IfThenElse question.. (2003)
New public beta available (1997)