Hi Marcos,
you can use simple string-functions to manage this.
For example:
dd/mm/yyyy -> yyyy-mm-dd
CONCAT_WS('-',RIGHT('dd/mm/yyyy',4),SUBSTRING('dd/mm/yyyy',4,2),LEFT('dd/mm/yyyy',2))
CONCAT_WS(separator, string_1 ,string_2 ...) puts strings together with separato
RIGTH(string,N) gives the first N chars of string
LEFT(string,N) gives the last N chars of string
SUBSTRING(string,pos,N) gives N chars of string from pos
prosit
Klaus
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
