Re: Problem with Date Format
| From: | Christian Reiniger | Date: | Fri, 05 Jan 2001 11:00:29 +0000 |
| Subject: | Re: Problem with Date Format | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-32866@lists.php.net to get a copy of this message | ||
On Friday 05 January 2001 09:07, davey sonya wrote:
> I need to retrieve a date which is in the format
> mm/dd/yy from my database and add 1 month to this
> date.
SELECT DATE_ADD(datefield, INTERVAL 1 MONTH) AS inc_datefield FROM ...
will give you the date + 1 month in MySQL
> I want to display this date as for eg 20 NOVEMBER
> 2000.
MySQL (and all other DBs I suppose) also has a function for date
formatting. check the manual.
--
Christian Reiniger
LGDC Webmaster (http://sunsite.dk/lgdc/)
"World domination. Fast." (Linus Torvalds about Linux)