Date format problem

dcjones

Hi all,

I have this code:

$datedis = $row_despatch['dis_date'];
echo date("d-m-Y", strtotime($datedis));

The result is "01-01-1970".

The date stored in the SQL table is 2009-05-30 and I am trying to echo out "30-05-2009"

Can anyone see what I am doing wrong.

bradgrafelman

dcjones wrote:
Can anyone see what I am doing wrong.

Yup; not using the right tool for the job. :p

Depending upon the DBMS you're using (assuming you're using a DBMS, that is), there should be built-in functions to deal with dates. For example, in MySQL you would use the DATE_FORMAT() function.