Re: time format

This WebDNA talk-list message is from

2005


It keeps the original formatting.
numero = 62724
interpreted = N
texte = Patrick McCormick wrote: > what's the proper syntax for formatting time? > > I want 17:30:00 in the database to display like 5:30 pm. > > [format %I:%M%p][evtime][/format] isn't working > > neither is [format time %I:%M%p][evtime][/format] > > Be nice if the docs addressed this. > > Pat Append your time to the database like: [math]{[time]}[/math] This changes the time to "Seconds since Midnight". Parse it for display with [format Secs_to_TIME perams] Then, sort it as a number as apposed to time. (thats the way, uh-huh uh-huh, I like it, uh-huh uh-huh) See: http://webdna.smithmicro.com/ref/pages.html?context=MathContext.html "TIME MATH" for more info. Donovan -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE Euca Design Center <-Web Development (specializing in eCommerce), -> <- Graphic Design, Custom Tags and Labels -> ADDRESS:> Donovan Brooke Euca Design Center 1871 HWY MM Fitchburg, WI 53575 PH:> 1.608.835.2476 Web:> http://www.egg.bz http://www.euca.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o ------------------------------------------------------------- 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: Time formatting in linux ( Gary Krockover 2006)
  2. Re: Time formatting in linux ( Phil Herring 2006)
  3. Re: Time formatting in linux ( Gary Krockover 2006)
  4. Time formatting in linux ( Phil Herring 2006)
  5. Re: time format ( Patrick McCormick 2005)
  6. Re: time format ( Donovan Brooke 2005)
  7. Re: time format ( Donovan Brooke 2005)
  8. time format ( Patrick McCormick 2005)
  9. Re: MySQL TIME FORMAT ( Robert Mosebar 2005)
  10. Re: MySQL TIME FORMAT ( "Nitai @ ComputerOil" 2005)
  11. Date and Time Format changes in WC4 (Glenn Busbin 2000)
Patrick McCormick wrote: > what's the proper syntax for formatting time? > > I want 17:30:00 in the database to display like 5:30 pm. > > [format %I:%M%p][evtime][/format] isn't working > > neither is [format time %I:%M%p][evtime][/format] > > Be nice if the docs addressed this. > > Pat Append your time to the database like: [math]{[time]}[/math] This changes the time to "Seconds since Midnight". Parse it for display with [format Secs_to_TIME perams] Then, sort it as a number as apposed to time. (thats the way, uh-huh uh-huh, I like it, uh-huh uh-huh) See: http://webdna.smithmicro.com/ref/pages.html?context=MathContext.html "TIME MATH" for more info. Donovan -- =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o DONOVAN D. BROOKE Euca Design Center <-Web Development (specializing in eCommerce), -> <- Graphic Design, Custom Tags and Labels -> ADDRESS:> Donovan Brooke Euca Design Center 1871 HWY MM Fitchburg, WI 53575 PH:> 1.608.835.2476 Web:> http://www.egg.bz http://www.euca.us =o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o=o ------------------------------------------------------------- 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/ Donovan Brooke

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:

date math [2.x] (1999) Emailer help....! (1997) [OT] Might be of interest... (2006) Date search - yes or no (1997) Search Criteria (2000) RE: Web*SSL and WebCatalog (1997) .. more on sliding discounts... (1997) [WebDNA] POST method using TCPSend (2013) listfiles shows invisible files ... (1999) comma-delimited email (1998) shownext not showing next...still r2 (1997) WebCat2b13MacPlugIn - more [date] problems (1997) no global [username] or [password] displayed ... (1997) [OT] (waaaay OT) (2004) OT: CT Scan might have saved my life!! (2006) headers (2004) [ListWords] BUG? (2003) Interfacing WebMerchant to www.fedex.com (1997) WebCat2b13MacPlugIn - syntax to convert date (1997) syntax question, not in online refernce (1997)