help with date

[doforumda]

hi i get date of birth of db. now i want to split day month and year from that date and put them in different variables.

e.g,

$dob = $row['dob'];

 

how would i do this?

[trq]

What does $row['dob'] look like?

[doforumda]

it looks like yyyy-mm-dd format

[trq]

Then take a look at strtotime and then date.

[kenrbnsn]

Why use those two functions when you can use explode?

<?php
list($year,$mon,$day) = explode('-',$row['dob']);
?>

 

Ken

[Seaholme]

I think another option might be something like extracting a substring from the string you already have.

 

You can see the command to do it on this page here, in the top table, 6th one down: http://www.redhat.com/docs/manuals/database/RHDB-7.1.3-Manual/sql/functions-string.html