Re: MySQL Dates and WebDNA

This WebDNA talk-list message is from

2005


It keeps the original formatting.
numero = 61180
interpreted = N
texte = And fort he benefit of persons who want the same information late= r there is the way with "raw": founditems] [field seek=3Dnamed:mydate&get=3Dvalue&raw=3DT] [/founditems] this would display 2005-02-22 To display this in European format: [founditems] [date ymd=3D[field seek=3Dnamed:mydate&get=3Dvalue&raw=3DT]&forma= t=3D%d/%m/%Y] [/founditems] I have updated the online docs with this snippet, also. Nitai -- Redakto - Content Management that simply works Content Management & eBusiness Systems ComputerOil=C2=AE AG Dammstrasse 7 5400 Baden / Switzerland Telefon +41 (0)844 44 55 66 info@computeroil.com http://computeroil.com > -----Original Message----- > From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On B= ehalf Of > Scott Anderson > Sent: Mittwoch, 23. Februar 2005 19:24 > To: WebDNA Talk > Subject: Re: MySQL Dates and WebDNA > > 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=20= a > 'normalized' format, which is then displayed according to your=20= WebDNA date > display prefs. For example: > > [date ymd=3D2005-12-25] > > For my settings this displays as 12/25/2005 > > This should also help with 'date' math, when you need to be cer= tain how a > date will be interpreted when it is used as input in an equatio= n. > > -----Original Message----- > From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Be= half Of > Nitai @ ComputerOil > Sent: Wednesday, February 23, 2005 08:52 AM > To: WebDNA Talk > Subject: MySQL Dates and WebDNA > > > Hi all > > I 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 =E4=B6=95-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=A6 > > TIA for any help. > > Nitai > > -- > Redakto - Content Management that simply works > Content Management & eBusiness Systems > > ComputerOil=C2=AE AG > Dammstrasse 7 > 5400 Baden / Switzerland > Telefon +41 (0)844 44 55 66 > > info@computeroil.com > http://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 digest@talk.smithmicro.com> > 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 digest@talk.smithmicro.com> > 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:

    
  1. Re: MySQL Dates and WebDNA ( "Nitai @ ComputerOil" 2005)
  2. Re: MySQL Dates and WebDNA ( "Scott Anderson" 2005)
  3. MySQL Dates and WebDNA ( "Nitai @ ComputerOil" 2005)
And fort he benefit of persons who want the same information late= r there is the way with "raw": founditems] [field seek=3Dnamed:mydate&get=3Dvalue&raw=3DT] [/founditems] this would display 2005-02-22 To display this in European format: [founditems] [date ymd=3D[field seek=3Dnamed:mydate&get=3Dvalue&raw=3DT]&forma= t=3D%d/%m/%Y] [/founditems] I have updated the online docs with this snippet, also. Nitai -- Redakto - Content Management that simply works Content Management & eBusiness Systems ComputerOil=C2=AE AG Dammstrasse 7 5400 Baden / Switzerland Telefon +41 (0)844 44 55 66 info@computeroil.com http://computeroil.com > -----Original Message----- > From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com] On B= ehalf Of > Scott Anderson > Sent: Mittwoch, 23. Februar 2005 19:24 > To: WebDNA Talk > Subject: Re: MySQL Dates and WebDNA > > 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=20= a > 'normalized' format, which is then displayed according to your=20= WebDNA date > display prefs. For example: > > [date ymd=3D2005-12-25] > > For my settings this displays as 12/25/2005 > > This should also help with 'date' math, when you need to be cer= tain how a > date will be interpreted when it is used as input in an equatio= n. > > -----Original Message----- > From: WebDNA Talk [mailto:WebDNA-Talk@talk.smithmicro.com]On Be= half Of > Nitai @ ComputerOil > Sent: Wednesday, February 23, 2005 08:52 AM > To: WebDNA Talk > Subject: MySQL Dates and WebDNA > > > Hi all > > I 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 =E4=B6=95-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=A6 > > TIA for any help. > > Nitai > > -- > Redakto - Content Management that simply works > Content Management & eBusiness Systems > > ComputerOil=C2=AE AG > Dammstrasse 7 > 5400 Baden / Switzerland > Telefon +41 (0)844 44 55 66 > > info@computeroil.com > http://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 digest@talk.smithmicro.com> > 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 digest@talk.smithmicro.com> > 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/ "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:

WebCat2final1 crashes (1997) Who is doing sign-ups-got it (1998) Search returns all, not 20 (1997) Round up prices (2000) RePost: NAT and the CART (1999) ShowNext (was New WebCatalog Site) (1997) Strange intermittent WebDNA problems (2008) PixelPipe for Windows? (2003) Digest Version (2000) How true is this? (1999) Error page mapping problems (2002) Writing to disk (1999) Help!!!! Purchases not going through! FIXED! (1997) .html processing? (1998) WebDNA-Talk Digest mode broken (1997) New WebDNA Solutions ... (1997) Re2: AAgghh!! Help, please. SSL strikes again. (1997) Multiple catalog databases and showcart (1997) Giving out error pages (1997) more ! testing (1997)