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 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
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
