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:

Help- Spam Bots are spamming my site. (2007) emailer w/F2 (1997) WC2f3 (1997) Time math (2002) WebCat2 - many [carts] on one template page? (1997) boldwords funky (1998) tcpconnect/tcpsend frustrations (2002) Fw: Linux w/ apache (2000) CommandSecurity? (1997) Problem with 2.1b3 (1997) emailer (1997) Xserve Recommendations (2003) PSC recommends what date format yr 2000??? (1997) WebMerch/Emailer Error (1998) 2.0 Info (1997) WebCatalog vs. Cold Fusion (1998) WebCatalog 2.0 b 15 mac (1997) Intermitent problem using [referrer] (1997) Emailer [cart] file names (1997) Problem with version 4 browsers (1998)