[RESOLVED] Print date from integer(8) formated row

[efeene]

Hi
I have a date formated in MySQL as int(8).
I know that Timestamp is better for dates/times, but for now I don't want to change.

How can I print the date value from a formated int(8) ?

I appreciate any help.
Thanks

[NogDog]

If it's YYYYMMDD, you can just do this:

$date = "20060827";
echo date("Y/m/d", strtotime($date));

[notaloser]

**edit forgot about strtotime, use that

[efeene]

Thanks for reply
If I use your example date appears OK, but if I change to

$date = "27082006"; 
echo date("d/m/Y", strtotime($date)); 

the result is that: 31/12/1969

In any way I cannot have in account that as much the day as the month have 2 numbers. Because the day or month 09 is stored like 9.
One example of an inserted date from your example is "8272006" (njY).

Any ideia to solve this
Thanks
FN

[bradgrafelman]

efeene wrote:

Any ideia to solve this

The easiest suggestion? Store your dates in a proper format.

[efeene]

SOLVED

I change TABLE Attributes to UNSIGNED ZEROFILL, if I have a date value like "882006" the value stored is changed to "08082006".

$datein="08282006"; //value in mdY with "" to retain the first zero
$mm=substr($datein,0,2);
$dd=substr($datein,2,2);
$yyyy=substr($datein,4,4);
echo "$dd-$mm-$yyyy";