Jump to content

Archived

This topic is now archived and is closed to further replies.

brittny85

Dates trouble

Recommended Posts

I'm trying to pull dates from a database and then use them like I would with the getDate() function. I would like to be able to take the dates from my MySQL database and break them into an array that would allow me to pull out the particular elements (i.e. month, day, year) and then manipulate those elements. Is there an easy way to do this? I was thinking it would probably have something to do with the mktime() or date() functions but I haven't been able to figure it out. I hope my question makes sense...

Thanks!
-Brittny

Share this post


Link to post
Share on other sites
Do you just want to edit the way the day, month and year appears if so you can just do this:

[code]$row['daterow'] = "2006-04-11 11:21:28";
date("d / m / Y", strtotime($row['daterow']));[/code]

This will then reformat the mysql date

Share this post


Link to post
Share on other sites
That's not quite what I was trying to do. I would like to take out the values for the month, year etc. and be able to use those values in my program. So that I could use it in a comparison like:
[code] $date['mday'] == $x[/code]

Sorry if I'm not making much sense, I haven't had much sleep. :)

Thanks!
-Brittny

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.