RE: [PHP] Working with dates in PHP

2002-10-10 Thread David Freeman
> I am at my wits end at the moment. I am pulling a > datetimestamp out of a database and attempting to > get the year month and day out of it. Do it in your sql query. Check out chapter 6 of the MySQL manual for ways to manipulate dates. Eg. $query = "select DATE_FORMAT(DTStamp, '%e %b

Re: [PHP] Working with dates in PHP

2002-10-10 Thread Tom Rogers
Hi, Friday, October 11, 2002, 3:53:55 PM, you wrote: JP> I am at my wits end at the moment. I am pulling a datetimestamp out of a JP> database and attempting to get the year month and day out of it. However JP> I am stumped as how to do it. JP> The format is "-MM-DD HH:MM:SS" and its com

[PHP] Working with dates in PHP

2002-10-10 Thread James Purser
I am at my wits end at the moment. I am pulling a datetimestamp out of a database and attempting to get the year month and day out of it. However I am stumped as how to do it. The format is "-MM-DD HH:MM:SS" and its coming out of a mySQL database. Is there anyway I can get the informatio