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:

[protect admin] (1997) migrating from MacOS to unix (2000) Problems with [Search] param - Mac Plugin b15 (1997) problems with 2 tags shakur (1997) my price won't move (1997) Help on how to store calculated value (2002) Shownext from POST (2000) Error handling for accountNum (1997) Need relative path explanation (1997) Users.db (1998) F3 crashing server (1997) [listfiles] anomaly (2003) WebCat2b15MacPlugIn - [authenticate] not [protect] (1997) Include a big block of text (1997) How do _you_ back up your db? (2000) [WebDNA] Apple nixes Mac OS Server ("websites") and other (2018) MacAuthorize hub, no modal password dialog? (1997) t or f (1997) A quickie question (1997) [Switch] - works great, suggestion (2000)