Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2004
    Posts
    7

    Unanswered: time field without seconds

    Hi
    I want a time field without seconds i.e only HH:MM.
    How can this be done??If not the how can I only extract the hours and minutes?
    Thanks

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    Have a look at the MySQL date & tme functions int he help file- time_format may do what you want.

    However unless you are doing some form of processing based on time then I'd of thought the natural place for this functionality would be some form of formatting within the display system. Ie some form of function / format in the application, whether that be PHP, C++, ASP etc.

    In a vb environment it would be format([mytime],"HH:MM")

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •