hi all, question abour ereg.

Zyanid

I have a variable that
looks like this "2003-01-22 08:00:00".

What must i do to change it to just the date and not the time?
I need to do this with ereg so if anyone know how to do it you would make me happy! =)

ereptur

why do you need to do this with ereg. That would be the complete wrong way of doing it. It could be done, but it would not be pretty.

The best method to use would be a
list($date,$time) = split(" ",$datetime);

otherwise, if you must use ereg, then I think this should work
$date = ereg("[0-9][0-9][0-9][0-9]-[0-9][0-9]-[0-9][0-9]",$datetime);

Zyanid

Thanks alot man.

The split solved my problem. =)

Now my site is allmost complete.

//Johan

sijis

maybe something like this this could work too

$db_date = "2003-01-22 08:00:00";
$new_date = date('Y-m-d',$db_date);

echo $new_date;

it should return:

2003-01-22

http://www.php.net/manual/en/function.date.php

bobthedog

Originally posted by sijis
maybe something like this this could work too

$db_date = "2003-01-22 08:00:00";
$new_date = date('Y-m-d',$db_date);

echo $new_date;

it should return:

2003-01-22

http://www.php.net/manual/en/function.date.php

Actually - wouldn't that be :

$new_date = date('Y-m-d', strtotime($dbdate));

since [man]date/man takes an integer timestamp as the second argument and not a date string.

sijis

bobthedog

well i guess that depends on how the date is stored in the db.

if the date is stored in Timestamp that's an INT right?

then i guess i wouldn't need to do strtotime($db_date).

i could be wrong though.

bobthedog

Indeed you wouldn't need it. But all the examples given presented it as a string 🙂

Zyanid

The split ereptur suggested worked great and was easy to use. I recommend trying it for those who need to do the same thing as i did. =)

//Z