Patric de Waha wrote:
> I live in Luxemburg (europe) and we are used to this form dd/mm/yy.
> I use www-sql which has no string manipulation functions,
> which means I've no possibility to change the input
> date (dd/mm/yy) to the yy/mm/dd which mysql expects.
> Ok now can do that?!
> insert into tblpersons dtbirthdate values
> I m looking for something like that :)
> Patric de Waha
You have two choices:
1) Write an UDF that does the translation.
2) Use this (slow) INSERT:
, SUBSTRING('04/08/79', 4, 2)
, LEFT('04/08/79',2) )