use DATE_FORMAT(date, format)
e.g:
DATE_FORMAT("1999-12-01", "%M %e, %Y") -> "December 1, 1999"
*taken from Paul Dubois MySQL book
BRgds,
--
Richard Bornay
Test Data Managment
ST Assembly Test Services
6824-1367
"Marcos Pomar" <[EMAIL PROTECTED]> 20/06/2003 05:36 PM
To: [EMAIL PROTECTED]
cc: (bcc: BORNAY Richard/Engr/STATS/ST Group)
Subject: Exists anything like Oracle TO_DATE('31/12/2003','dd/mm/yyyy') ?
Hi everybody,
Is there any function like Oracle TO_DATE in order to insert a date into a
DATE type field according to a different format than yyyy-mm-dd? I wish to
insert a date into a date field but my date format is "dd/mm/yyyy". If
not,
is there any workaround using mysql functions? AFAIK mysql reference does
not mention this...
Thanks,
Marc Pomar
_________________________________________________________________
Dale rienda suelta a tu tiempo libre. Encuentra mil ideas para exprimir tu
ocio con MSN Entretenimiento. http://entretenimiento.msn.es/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
