Duh! Nice. Sorry I missed it.
-Clark
- Original Message
From: Igor Tandetnik <[EMAIL PROTECTED]>
To: SQLite
Sent: Friday, August 18, 2006 11:22:18 AM
Subject: [sqlite] Re: Re: Using Wrong Date Format
Clark Christensen
wrote:
>> update tableName set
>> DOB=subst
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
2 matches
Mail list logo