James Hatridge wrote:
> Hi all,
>
> I have records with the date in DD-MM-, but mysql wants them in
> -MM-DD. Is there anyway of changing Mysql's format?
>
> Thanks,
>
> JIM
>
I believe MySQL run there own mailing lists to deal with MySQL issues, I
would suggest going to the relevant My
On Wednesday 11 April 2007 09:42, James Hatridge wrote:
> Hi all,
>
> I have records with the date in DD-MM-, but mysql wants them in
> -MM-DD. Is there anyway of changing Mysql's format?
I'm not 100% sure, but I checked a couple of references and it appears
that while MySQL has a certain
On Wednesday 11 April 2007 09:42:36 am James Hatridge wrote:
> Hi all,
>
> I have records with the date in DD-MM-, but mysql wants them in
> -MM-DD. Is there anyway of changing Mysql's format?
>
Um, my suggestion would be to do some kind of CAST or CONVERT. I'm not so
familiar with MySQL
On Wed, 2007-04-11 at 18:05 +0100, Hans du Plooy wrote:
> On Wed, April 11, 2007 17:54, Adam Tauno Williams wrote:
> >> I have records with the date in DD-MM-, but mysql wants them in
> >> -MM-DD. Is there anyway of changing Mysql's format?
> > I don't EVER use MySQL;
> Please don't make a
there are plenty of functions to work with DATE in mysql, check this:
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
~ig
On 4/11/07, Hans du Plooy <[EMAIL PROTECTED]> wrote:
On Wed, April 11, 2007 17:54, Adam Tauno Williams wrote:
>> I have records with the date in DD-MM-Y
On Wed, April 11, 2007 17:54, Adam Tauno Williams wrote:
>> I have records with the date in DD-MM-, but mysql wants them in
>> -MM-DD. Is there anyway of changing Mysql's format?
>
> I don't EVER use MySQL;
Please don't make a statement like that without explaining why. I can
think of a f
> I have records with the date in DD-MM-, but mysql wants them in
> -MM-DD. Is there anyway of changing Mysql's format?
I don't EVER use MySQL; but with most databases this is just a matter
of changing your locale. Should be doable via an environment variable
(client side) or a paramete
Hi all,
I have records with the date in DD-MM-, but mysql wants them in
-MM-DD. Is there anyway of changing Mysql's format?
Thanks,
JIM
--
Jim Hatridge
Linux User #88484
Ebay ID: WartHogBulletin
--
WartHog Bulletin
In
