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:

[WebDNA] 2nd pair of eyes on redirect please (2011) Looking for easy way to back up dbs... (2003) Running _every_ page through WebCat ? (1997) Auto Date (2001) OT - SMSI complaint (2001) More on the email templates (1997) creator code (1997) [isfile] ? (1997) WebCatalog Plug-in for Webstar. (1997) Tax & Shipping (1997) search / summary (2005) Multiple 'Users.db' files not possible (1997) WebDelivery downloads alias, not original ? (1997) archiving images (2006) Cart Number sequence (1997) Request for page test (2003) URL for Discussion Archive (1997) Trigger alternatives please ... (2004) search form problem.. (1997) Ampersand (1997)