Re: [sqlite] Re: Using Wrong Date Format

2006-08-18 Thread Clark Christensen
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

Re: [sqlite] Re: Using Wrong Date Format

2006-08-18 Thread Gerry Snyder
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);

[sqlite] Re: Using Wrong Date Format

2006-08-18 Thread Igor Tandetnik
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