Getting day in a date

Anon

Dear All,
I have a variable that is coming from mysql as datetime format(i.e.,2002-02-03 07:09:18)
How can I get the date from this datatype? Is there is any function available for this otherwise I have to go for substr() function? Please help me.
regards,
Indrajit.

van__

$SQL = SELECT DATE_FORMAT(datefield,'%d') as date FROM myTable";

and never ever use a string function to do the job of a regex.

$date = preg_replace('/[0-9]{4}-([0-9]{2})-[0-9]{2}/', '//1',$date);

Anon

Eh? A lot of the time the string function would be faster - save you the overhead of setting up the regexp engine.

Then again, strtotime recognises this format, so you can do:

date('d',strtotime($date))

khaine

You could just use explode.

$datetime="2002-02-03 07:09:18"
list($date, $time)=explode(" ", $datetime);

this would get you the time and date in seperate fields. You could explode again if you wanted the date split up.

Mark.

van__

Ya, I agree about the regex, but then again, I was assuming he'd just do it through MySQL Query which would just plop out the preformatted number without an additional function call.

I'm just a str_func hater I guess, mainly because I see people resorting to 3 str funct calls rather than 1 regex call...
or even worse writing an entire string parsing function of 6 plus lines to do what I can do with 1 regex with far more flexibility.

Anon

I agree entirely about abuse of str* functions; it's just that I'm slightly more irritated at things like eregi_replace(" ","_",$string). I just wish I knew what optimisations the Zend Optimizer actually does.

Anon

Many many thanks for you three people.

van__

I hear you about the zend optimizer,
I have a lot of questions and I'm getting ready to buy it, but haven't gotten a call or email or anything from the contact I sent them for sales help.

Which really irks me because I have gaggles of questions and the online FAQ sucks.

Guess I'll just have to take a week to install the evaluation copy and test drive it with my code to get a feel for it's strengths and weaknesses.