MySQL TIME_FORMAT

This WebDNA talk-list message is from

2005


It keeps the original formatting.
numero = 61873
interpreted = N
texte = I am trying to format a time value from MySQL in AM/PM format but 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 get in the listing is the "r" character. These commands work fine when run in a MySQL database management 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 Web Archive of this list is at: http://webdna.smithmicro.com/ Associated Messages, from the most recent to the oldest:

    
  1. MySQL TIME_FORMAT ( Robert Mosebar 2005)
I am trying to format a time value from MySQL in AM/PM format but 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 get in the listing is the "r" character. These commands work fine when run in a MySQL database management 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 Web Archive of this list is at: http://webdna.smithmicro.com/ Robert Mosebar

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:

Error Template (1999) Serial Number Question (1997) maximu values for sendmail! (1997) Protect (1997) [Price] (1997) Download (1999) WebCat2: Found Items syntax, etc. (1997) File Uploads... (1997) WebCatalog-NT?'s (1996) idear about how to get SMSI to speak. (2006) downloading a file in it's own browser window? (2002) WebDNA or WebCatalog4.0.2 on Redhat 7.3 System (2003) weight based shipping cost questions (1997) [REFERRER] AND Truncation (1998) WebCat2: Items xx to xx shown, etc. (1997) triggers have stopped once again (2002) WebDelivery downloads alias, not original ? (1997) Now you see it now you donīt (1997) Associative lookup style? + bit more (1997) Possible Bug in 2.0b15.acgi (1997)