Simple format date from MySQL database

[danwednesday]

Hi,

I've got a date being pulled from a MySQL date field. In the database the date look like this:

2007-05-10

I want to format this so it appears:

10th May 07


I've tried this:

print date("j M y",$db_field['tstamp'])

But that renders in the browser as:

1 Jan 70



It should say 10 May 2007.

Can anyone see why this is happening?

Thanks folks...

[barbara1712]

Use the following query

select *, date_format(date_field_name,'%D %b %y') as MyDate from table_name;

[Hartmann]

Hi,

I've got a date being pulled from a MySQL date field. In the database the date look like this:

2007-05-10

I want to format this so it appears:

10th May 07


I've tried this:

print date("j M y",$db_field['tstamp'])

But that renders in the browser as:

1 Jan 70



It should say 10 May 2007.

Can anyone see why this is happening?

Thanks folks...

What do you get when you just print that field out without formatting?

[danwednesday]

What do you get when you just print that field out without formatting?

Just 2007-05-10

[Hartmann]

Just 2007-05-10

Just realized something obvious, that is a date string you are passing, while the date function takes in a true timestamp, which is why you are getting the weird date.

Try this:

print date("j M y", strtotime($db_field['tstamp'])) 

[danwednesday]

Perfect, thanks very much Hartmann!