Date Seperation

Anon

Hi coders,

This seems like a simple task, I just thought rather than reading to learn Its easier to learn by example.

I have a Date Field in the Database which returns me a date in this format

DD-MM-YYYY

Now from that I want to get just the MM-YYYY and remove the DD.

I think I could do this with ereg or ereg_replace.

The only thing is I hate this ereg command since everytime I look at an example, it makes my eyes go blurry.

Thanks to anyone who can help

-regards-
UniMatrix

[deleted]

"I just thought rather than reading to learn Its easier to learn by example."

not in this case 🙂
rule #1 in getting data from the database is: let the database do the work.

Every database has (a) function(s) that lets you format the date right inside your select statement. This is always faster than doing it manually afterwards.

Open the manual of your database and look in the date functions section.

A forum, a FAQ, what else do you need?

Time to YAPF!: http://www.hvt-automation.nl/yapf/

Anon

What if I want to do it manually after the Database Query?

Rather than inside the SQL Statement....

-regards-
UniMatrix

[deleted]

That would be a very silly thing to do.

But if you really want to then you should get the database to output the date as a timestamp which you can them format using things like strftime().

But it's better to let the database do it.

A forum, a FAQ, what else do you need?

Time to YAPF!: http://www.hvt-automation.nl/yapf/

Anon

Well I'll have a look to see if I can get the Database side working If I have n e trouble at least I'll know where to come.

-regards-
UniMatrix