Re: MySQL TIME FORMAT

This WebDNA talk-list message is from

2005


It keeps the original formatting.
numero = 61874
interpreted = N
texte = Hi there You can always get the fields from the MySQL Database displays a=20= "raw" format and then do the formatting or anything alike. I have wrote a little function that, for example, shows the date=20= in the European format which is different then the day that MySQL= stores them internally. To get the field in raw format use: [founditems] [date ymd=3D[field seek=3Dnamed:mydate&get=3Dvalue&raw=3DT]&forma= t=3D%m/%d/%Y] [/founditems] Hope this helps. Nitai -- Redakto CMS - Content Management that simply works Redakto eServices - Professional WebHelpDesk Redakto ImagePark - Innovative Asset Management 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 > Robert Mosebar > Sent: Freitag, 29. April 2005 23:50 > To: WebDNA Talk > Subject: MySQL TIME_FORMAT > > I am trying to format a time value from MySQL in AM/PM format b= ut > getting a MySQL error when running the page. The SL command is:= > > SELECT TIME_FORMAT(action_time,'%I:%i%s %P') FROM transaction_= log > > The error displayed seems to vary each time it is run. If I try= : > > SELECT TIME_FORMAT(action_time,'%r') FROM transaction_log > > which is a quick format, the page doesn't error out but all I g= et in > the listing is the "r" character. > > These commands work fine when run in a MySQL database managemen= t tool > such as YourSQL. > > Is this a function WebDNA does not support? If so, how do I get= to an > AM/PM format with my dates? > > Thanks. > > > ------------------------------------------------------------- > 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 TIME FORMAT ( Robert Mosebar 2005)
  2. Re: MySQL TIME FORMAT ( "Nitai @ ComputerOil" 2005)
Hi there You can always get the fields from the MySQL Database displays a=20= "raw" format and then do the formatting or anything alike. I have wrote a little function that, for example, shows the date=20= in the European format which is different then the day that MySQL= stores them internally. To get the field in raw format use: [founditems] [date ymd=3D[field seek=3Dnamed:mydate&get=3Dvalue&raw=3DT]&forma= t=3D%m/%d/%Y] [/founditems] Hope this helps. Nitai -- Redakto CMS - Content Management that simply works Redakto eServices - Professional WebHelpDesk Redakto ImagePark - Innovative Asset Management 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 > Robert Mosebar > Sent: Freitag, 29. April 2005 23:50 > To: WebDNA Talk > Subject: MySQL TIME_FORMAT > > I am trying to format a time value from MySQL in AM/PM format b= ut > getting a MySQL error when running the page. The SL command is:= > > SELECT TIME_FORMAT(action_time,'%I:%i%s %P') FROM transaction_= log > > The error displayed seems to vary each time it is run. If I try= : > > SELECT TIME_FORMAT(action_time,'%r') FROM transaction_log > > which is a quick format, the page doesn't error out but all I g= et in > the listing is the "r" character. > > These commands work fine when run in a MySQL database managemen= t tool > such as YourSQL. > > Is this a function WebDNA does not support? If so, how do I get= to an > AM/PM format with my dates? > > Thanks. > > > ------------------------------------------------------------- > 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:

WebCat2 - Getting to the browser's username/password data (1997) Frames and WebCat (1997) WebCat2 Append problem (B14Macacgi) (1997) Another reviewer 'forgets' NT WebCatalog (1998) oddball sorting problem (2003) Serving images from databases (1998) Test (2002) date display (1999) Serial Number Question (1997) Generating unique SKU from [cart] (1997) Install Webcatalog under NT4.0 and Microsoft IIS 2.0 (1997) Sticky .inc file! (2008) Initiating NewCart (1997) Tab Charactor (1997) WebDNA 5.1 is now available! (2003) Problem displaying search result (1997) Order not created error (1997) math a various prices (1997) MIMEHeaders (2004) Search (1997)