Clark Christensen 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. Does SQLite convert > YYYYMMDD date strings?
Look more carefully. The middle term is of length 4 - it will pick up "-mm-" from the middle of the original string. -- Nikki Locke, Trumphurst Ltd. PC & Unix consultancy & programming http://www.trumphurst.com/ ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
