Duh! Nice. Sorry I missed it. -Clark
----- Original Message ---- From: Igor Tandetnik <[EMAIL PROTECTED]> To: SQLite <sqlite-users@sqlite.org> Sent: Friday, August 18, 2006 11:22:18 AM Subject: [sqlite] Re: Re: Using Wrong Date Format 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] ----------------------------------------------------------------------------- ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------