Clark Christensen <cdcmicro-/[EMAIL PROTECTED]>
wrote:
update tableName set
DOB=substr(DOB,7,4)||substr(DOB,3,4)||substr(DOB,1,2);
Am I missing some magic here? To me, this looks like it'll result in
YYYYMMDD.
substr(DOB,3,4) extracts the day complete with surrounding dashes from
the original string.
Igor Tandetnik
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
