Re: [cobalt-developers] parse date in php and mysql

["John McGill" <jmcgill_maillists@xxxxxxxxxxxxxxxxxxxxxx>]

Hi,
    To retrieve the date in the format you require I would use the following
SQL:

SELECT *,
DATE_FORMAT(RenewalDate,'%d/%m/%Y') AS fRenewalDate
FROM tblDomains
WHERE DomainID = $Domain";

Obviously you'd have to change the SQL to match your table names etc but the
relevant part is the "DATE_FORMAT()".

Regards,
            John


----- Original Message -----
From: "nick 76" <njd76@xxxxxxxxxxx>
To: <cobalt-developers@xxxxxxxxxxxxxxx>
Sent: Thursday, April 03, 2003 3:02 AM
Subject: Re: [cobalt-developers] parse date in php and mysql


>
> its in there as a date format
>
> >From: "Ontario Web System Administrator" <hostmaster@xxxxxxxxxxxxx>
> >Reply-To: cobalt-developers@xxxxxxxxxxxxxxx
> >To: <cobalt-developers@xxxxxxxxxxxxxxx>
> >Subject: Re: [cobalt-developers] parse date in php and mysql
> >Date: Wed, 2 Apr 2003 19:42:07 -0500
> >
> >
> > > no luck
> >
> >What kind of format are you loading this into the Mysql?
> >
> >--
> >Best Regards, Jon
> >
> >_______________________________________________
> >cobalt-developers mailing list
> >cobalt-developers@xxxxxxxxxxxxxxx
> >http://list.cobalt.com/mailman/listinfo/cobalt-developers
>
>
> _________________________________________________________________
> Tired of spam? Get advanced junk mail protection with MSN 8.
> http://join.msn.com/?page=features/junkmail
>
> _______________________________________________
> cobalt-developers mailing list
> cobalt-developers@xxxxxxxxxxxxxxx
> http://list.cobalt.com/mailman/listinfo/cobalt-developers
>