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_logThe error displayed seems to vary each time it is run. If I try:SELECT TIME_FORMAT(action_time,'%r') FROM transaction_logwhich 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:
|
- 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_logThe error displayed seems to vary each time it is run. If I try:SELECT TIME_FORMAT(action_time,'%r') FROM transaction_logwhich 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:
HomePage Caution (1997)
Banners (1997)
international time (1997)
using showpage and showcart commands (1996)
problems with WebCat-Plugin (1997)
WebCat Linux: Could not create pipeKey segment (2000)
[WebDNA] JSONStore Levels (2020)
Tab Charactor (1997)
WebCat2 beta 11 - new prefs ... (1997)
Help! WebCat2 bug (1997)
passing along TextB (1999)
Simple way to create unique SKU (1997)
[math date] with non-US date format (2000)
READFILE command? (1998)
carriage returns in data (1997)
WebCat2b13MacPlugIn - [shownext method=post] ??? (1997)
WebCat b13 CGI -shownext- (1997)
Help formatting search results w/ table (1997)
Loosing Quantity (2000)
Presenting a .txt file (2000)