Converting a timestamp to a readable date in php?

DOLEMAN

Hey,

If I have a date stored in my database like this -

20060528000145

(YYYYMMDDHHMMSS)

- what's the easist way to convert it to this -

May 28, 2006 @ 00:01 PM

- in PHP? (notice I don't care about the seconds.)

Does anyone know?

Thank you.

Adam

[PHP]<?=format(gmdate("d-M-Y"),"dddd, dd mmmm")?>[/PHP]

Should do the trick, I dunno about the @ 00:01 PM bit though sorry! Thats GMT by the way.

DOLEMAN

Hey,

Thanks for the reply.

Am I right in thinking that will return the current date/time?

How do I pass in my variable with the unix timestamp?

Thanks!

Adam

Sorry, scratch that!! I have a whole function called 'format' behind that, it wont work for you! But that print method will give you the correct format, you've just got to write a little format function for yourself. As for passing the UNIX timestamp, just reformat it to unix as a variable for passing to the database.

JoeB-

Use
timeS = mktime($str[9].$str[10], $str[11].$str[12] ... etc)

to get a timestamp equivelent to your database string... you have to supply the values for the hour, min etc by choosing letters from your database string... ($str equals your database string and $str[12] = the 12th letter)

int mktime ( [int hour [, int minute [, int second [, int month [, int day [, int year [, int is_dst]]]]]]] )


then call
Date("M d, Y @ h:i A", timeS)

to convert the timestamp to the required format.

DOLEMAN

Actually... got it working...

my query... DATE_FORMAT(date, '%W, %M %d, %Y') AS date ...

Works grand!

Thanks for the help