Hi,
I think you can't.
You can create char field type on table (i.e. char(10)) and when you wish to
do some date comparison you can use the next mySQL
functions:LEFT,MID,RIGHT,TRIM.
I.E:
mydate->field in a_table:char(10);
date on this field: '10.01.2001','30.02.2000',...etc.
select * from a_table where RIGHT(mydate,4)<'2002';
select * from a_table where MID(mydate,4,2)='01';
...etc
Regards,
Gelu
_____________________________________________________
G.NET SOFTWARE COMPANY
Permanent e-mail address : [EMAIL PROTECTED]
[EMAIL PROTECTED]
----- Original Message -----
From: "Raph mysql" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 16, 2002 11:14 AM
Subject: Re: How to change DATETIME format ??
> mysql / query
> ----------------------------------------------------------------------
>
> I have a DATETIME column type with format YYYY-MM-DD and I'd like to have
> format DD-MM-YYYY
>
> what do I have to do ?
>
>
>
>
>
>
> _________________________________________________________________
> MSN Photos est le moyen le plus simple de partager et d'imprimer vos
photos
> : http://photos.msn.com/support/worldwide.aspx
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
