subject:"\[sqlite\] Re\: Re\: Using Wrong Date Format"

Re: [sqlite] Re: Re: Using Wrong Date Format

2006-08-18 Thread Clark Christensen

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 wrote: >> update ta

[sqlite] Re: Re: Using Wrong Date Format

2006-08-18 Thread Igor Tandetnik

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 MMDD. substr(DOB,3,4) extracts the day complete with surrounding dashes from the original string. Igor Tandetnik