Another date problem

discostudio

I have date-of-birth's stored in my customer database in the format

1953-05-15

Uno, the "date" type of field.

Now when I pull it out and split it into 3 variables for 3 different text boxes in my "update your profile" pages like this:

$dob_year = date("Y", strtotime($rm['DOB'])); 
						$dob_month = date("m", strtotime($rm['DOB'])); 
						$dob_day = date("d", strtotime($rm['DOB']));

I get the following date:

[01] [01] [1970]

and when I do the following:

 echo date("d/m/Y", strtotime($rm['DOB']));

I get:

01/01/1970

Huhh, am I missing something?

Someone help!

😃 Please

halojoy

How do you echo the first version?
The following code, as far I can see, should produce:
01 01 1970

$dob_year = date("Y", strtotime($rm['DOB']));  

$dob_month = date("m", strtotime($rm['DOB']));  

$dob_day = date("d", strtotime($rm['DOB']));

echo "$dob_day $dob_month $dob_year";

discostudio

Originally posted by halojoy
How do you echo the first version?
The following code, as far I can see, should produce:
01 01 1970
$dob_year = date("Y", strtotime($rm['DOB']));  

$dob_month = date("m", strtotime($rm['DOB']));  

$dob_day = date("d", strtotime($rm['DOB']));

echo "$dob_day $dob_month $dob_year";
[/B]

Yes but that is the problem, the dates I have in the datatbase are mainly well before 1970, surely:

1966-12-03

when echoed as follows:

echo date("d/m/Y", strtotime($rm['DOB']))

should come out as:

03/12/1966

Not:

01/01/1970

?? Still baffled.

wilku

But what comes out if you'd do

echo $rm['DOB'];

EDIT: Sorry, just noticed: strtotime() returns a timestamp and a timestamp can't represent a date before January the 1st, 1970.

discostudio

Originally posted by wilku
But what comes out if you'd do
echo $rm['DOB'];
? [/B]

1966-12-01

same as it is shown in the db column, why?

discostudio

Originally posted by wilku
But what comes out if you'd do
echo $rm['DOB'];
?

EDIT: Sorry, just noticed: strtotime() returns a timestamp and a timestamp can't represent a date before January the 1st, 1970. [/B]

So what can I do?

wilku

Ah, the question was to be expected 😉

You can parse the date yourself, example:

<?php
$rm['DOB'] = "1953-05-15 21:28";
$date = split(" ",$rm['DOB']);
$date = split("-",$date[0]);
echo $date[2]."/".$date[1]."/".$date[0];
?>

Or retrieve the date "ingredients" from database:

SELECT DAY(DOB) as dob_day, MONTH(DOB) as dob_month, YEAR(DOB) as dob_year FROM ...

EDIT: in case of having only a date (without time) just skip the first split.

Weedpacket

Or do the formatting within the query itself (using whichever date/time formatting functions your DBMS provides for use in SQL statements).