How do I turn a timestamp into a readable date?

User Name:

Password:

Remember me

		Dev Shed Forums > Databases > MySQL Help
How do I turn a timestamp into a readable date? Discuss How do I turn a timestamp into a readable date? in the MySQL Help forum on Dev Shed. How do I turn a timestamp into a readable date? MySQL Help forum discussing administration, SQL syntax, and other MySQL-related topics. MySQL is an open-source relational database management system (RDBMS).

Add This Thread To:

Del.icio.us

Digg

Google

Spurl

Blink

Furl

Simpy

Y! MyWeb

« Previous Thread | Next Thread »

Thread Tools

Search this Thread

Rate Thread

Display Modes

Dev Shed Forums Sponsor:

SlickEdit: Code in over 40 languages across 7 platforms. SlickEdit’s unmatched power, speed, and flexibility allows even the most accomplished developers to write better code faster. Download a free trial today!

October 8th, 1999, 10:57 PM

Skylance

Guest

Posts: n/a
Time spent in forums:
Reputation Power:

Here's my problem, I have a timestamp value in my database, and I'd like to be able to use PHP to take the value of the time stamp and turn from 19991005165611 into October 5 1999 4:56 PM (note that i don't need the seconds to be converted.) I really have no idea how to do this, If anyone has seen a routine that does this, or could write a quick one (I feel if you know how to do this it would be easy) It would be very helpful.

Thanks.

Viewing: Dev Shed Forums > Databases > MySQL Help > How do I turn a timestamp into a readable date?

« Previous Thread | Next Thread »

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox

Forum Jump