Re: MySQL TIME FORMAT
This WebDNA talk-list message is from 2005
It keeps the original formatting.
numero = 61874
interpreted = N
texte = Hi thereYou 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 worksRedakto eServices - Professional WebHelpDeskRedakto ImagePark - Innovative Asset Management ComputerOil=C2=AE AGDammstrasse 75400 Baden / SwitzerlandTelefon +41 (0)844 44 55 66 info@computeroil.comhttp://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:
Hi thereYou 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 worksRedakto eServices - Professional WebHelpDeskRedakto ImagePark - Innovative Asset Management ComputerOil=C2=AE AGDammstrasse 75400 Baden / SwitzerlandTelefon +41 (0)844 44 55 66 info@computeroil.comhttp://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)