Eoin Collins <[EMAIL PROTECTED]> wrote:
The database I'm currently using has a field Date Of Birth, and all enteries in are in dd-mm-yyyy format.I need them in yyyy-mm-dd format.
update tableName set DOB=substr(DOB,7,4)||'-'||substr(DOB,4,2)||'-'||substr(DOB,1,2);
Igor Tandetnik
----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------