date from datetimevariable

[Anon]

i want to get only the date part of a datetime variable in the record.variable are coming like 2002-05-11 15:13:02.933
i want to get it's part 2000-05-11 only
can anybody solve this problem

[Anon]

Your variable is 2002-05-11 15:13:02.933.
say
$field = "2002-05-11 15:13:02.933";

explode your variable on space like this-
$var2 = explode(" ",$field);
This will explode the variable at space and then give u an array which has elements seperated by space. u will get an array of size 2.
$var2[0] will give u required part,
other will have time.
~Njoi ~
$Bhushan 🙂