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:

Sort Order on a page search (1997) Here we go again... (2006) [WebDNA] New problem with [ShowNext] (2010) No luck with taxes (1997) possible, WebCat2.0 and checkboxes-restated (1997) typhoon... (1997) Which GUI HTML editors work with WC ? (1997) Sorting by date (1997) in string ??? (2001) Problems getting parameters passed into email. (1997) Separate SSL Server (1997) Count how many items in a summ total (2003) Any problems with Welcome & WebCat? (2000) Resume Catalog ? (1997) sort problems....bug or brain fart? (1997) Re2: Calculating multiple shipping... (1997) [WebDNA] AutoFill Drop Down Menu (2009) all records returned. (1997) creative use of webcatalog (1998) [Fwd: F3 database munching] (1997)