nks!
-Clark
- Original Message
From: Gerry Snyder <[EMAIL PROTECTED]>
To: sqlite-users@sqlite.org
Sent: Friday, August 18, 2006 5:54:22 AM
Subject: Re: [sqlite] Re: Using Wrong Date Format
Igor Tandetnik wrote:
> Eoin Collins <[EMAIL PROTECTED]>
> wrote:
>> The datab
Igor Tandetnik wrote:
Eoin Collins <[EMAIL PROTECTED]>
wrote:
The database I'm currently using has a field Date Of Birth, and all
enteries in are in dd-mm- format.
I need them in -mm-dd format.
update tableName set
DOB=substr(DOB,7,4)||'-'||substr(DOB,4,2)||'-'||substr(DOB,1,2);
Eoin Collins <[EMAIL PROTECTED]>
wrote:
The database I'm currently using has a field Date Of Birth, and all
enteries in are in dd-mm- format.
I need them in -mm-dd format.
update tableName set
DOB=substr(DOB,7,4)||'-'||substr(DOB,4,2)||'-'||substr(DOB,1,2);
Igor Tandetnik
3 matches
Mail list logo