change date 1

[manicleek]

can anyone tell me how I can take a date entered into a form as dd/mm/yyyy (in 1 text field with the slashes) and change it into yyyymmdd for mysql and also how to change back again

thanks

 

[kenrbnsn]

Take a look at

http://www.php.net/date

It should tell you all you need to know.

Ken

 

[manicleek]

OK I've got something putting a timestamp in my db but now on output I get

Warning: date(): Windows does not support dates prior to midnight (00:00:00), January 1, 1970 in C:\sites\blog\test.php on line 24

even though the year I put in was 1985!

 

[kenrbnsn]

Can we see your code? Usually that occurs if you have an error in the date() function call.

Ken

 

[manicleek]

sure

<?= date("d/m/Y",strtotime($rs["date"])) ?>

I even tried entering todays timestamp in the db and got the same error

 

[kenrbnsn]

How is the "date" field defined in your database? What displays if you echo $rs['date']? Where is $rs['date'] coming from?

Ken

 

[manicleek]

currently theres a date field, its set as a varchar and contains the date stamp '484095600' which should be '02/05/1985'

the date is entered into the db using the code

$day = $_POST['day'];
$month = $_POST['month'];
$year = $_POST['year'];

$date = strtotime($year."-".$month."-".$day);

then an insert sql statement

 

[kenrbnsn]

Ok, you're storing the UNIX date in your database as a string. Since the strtotime() function converts "pseudo english strings" to UNIX dates, you don't need to use it in the echo statement:

<?= date("d/m/Y",$rs["date"]) ?>

should produce what you're looking for.

Ken

 

[manicleek]

great, thanks