Page 2 of 2 First 12
  • Jump to page:
    #16
  1. Banned (not really)
    Devshed Supreme Being (6500+ posts)

    Join Date
    Dec 1999
    Location
    Brussels, Belgium
    Posts
    14,640
    Rep Power
    4476
    You guys may have already solved this already, but i just happened upon the question. there is a mysql function that will format the date/time column however you want it...

    date_format(column_name,'format_string')

    so, for your format, you'd have

    select date_format(date,"<b>d/m/y</b> h:i p") as fdate from body order by fdate desc;

    for am/pm

    or

    select date_format(date,"<b>d/m/y</b> H:i") as fdate from body order by fdate desc;

    for 24 hour time (military)

    just my $0.02..

    ---John Holmes...
  2. #17
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2000
    Location
    Boston MA USA
    Posts
    23
    Rep Power
    0
    its not working xactly correctly
    the top entry dosen't have the 2nd or 3rd field inputted
    hense why i posted above :P
    any thoughts?
Page 2 of 2 First 12
  • Jump to page:

Similar Threads

  1. adjusting time duration from a drop down menu
    By spyghost in forum HTML Programming
    Replies: 9
    Last Post: March 1st, 2004, 02:05 AM
  2. Text box Number formatting
    By Bijoos in forum Visual Basic Programming
    Replies: 6
    Last Post: February 17th, 2004, 09:19 PM
  3. time in - time out
    By newbiex in forum PHP Development
    Replies: 2
    Last Post: February 9th, 2004, 02:04 AM
  4. Replies: 0
    Last Post: February 1st, 2004, 11:13 AM
  5. Adding minutes to time and other calcs
    By Jez433 in forum PHP Development
    Replies: 5
    Last Post: January 21st, 2004, 06:00 PM

IMN logo majestic logo threadwatch logo seochat tools logo