Results 1 to 12 of 12

Thread: Get the Date & Time From A MySQL Time Stamp? -Solved[:)]-

Threaded View

  1. #1

    Thread Starter
    Frenzied Member wpearsall's Avatar
    Join Date
    Feb 2002
    Location
    England / UK
    Posts
    1,065

    Get the Date & Time From A MySQL Time Stamp? -Solved[:)]-

    OK, now if i create a record in my table, (mysql) i have a timestamp field, so it fills in like:

    20021201214855

    Translated To:
    Date: 01 December 2002
    Time: 21:48:55

    Now, i know its in the form:

    YearMonthDayHourMinuteSecond

    But, is there a way (Already made) That will make it into an easy to read manner?

    And if i can split it into the actual Date & Time seperate, Cool
    Last edited by wpearsall; Dec 2nd, 2002 at 05:57 PM.
    Wayne

Posting Permissions

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



Click Here to Expand Forum to Full Width