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

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 >>

Re: [sqlite] 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. Does SQLite convert > MMDD date strings? Look more carefully. The middle term is of

[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

Re: [sqlite] Re: Using Wrong Date Format

> 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. Does SQLite convert MMDD date strings? I would've gone with the original -MM-DD date string that Igor posted. Thanks!

Re: [sqlite] Using Wrong Date Format

Sqlite has functions date() and strftime() which can do what you want. Eoin Collins wrote: Hi, 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. Can anyone help me with this, please? Regards, Eoin

Re: [sqlite] multi threats parallel reading db

Hi, > > > Please double-check your code. The error message "library routine > > > called out of sequence" is what you get when you try to use the > > > the same database connection from more than one thread at one time. > > > > If I remember correctly, there are two other cases where "library

Re: [sqlite] macosx version installation

Roger Coupal <[EMAIL PROTECTED]> wrote: > Hi, > I'm new to SQlite and want to install it on my computer (macosx 10.4). > However, I'm not familiar with starkits. Could someone explain how we > "install it" or do not install it and so how do we run it. I went to the > starkit website and all I

[sqlite] macosx version installation

Hi, I'm new to SQlite and want to install it on my computer (macosx 10.4). However, I'm not familiar with starkits. Could someone explain how we "install it" or do not install it and so how do we run it. I went to the starkit website and all I found was how developers can use the formatting for

Re: [sqlite] multi threats parallel reading db

Tito Ciuro <[EMAIL PROTECTED]> wrote: > On Aug 18, 2006, at 6:45 AM, [EMAIL PROTECTED] wrote: > > > Please double-check your code. The error message "library routine > > called out of sequence" is what you get when you try to use the > > the same database connection from more than one thread at

Re: [sqlite] multi threats parallel reading db

On Aug 18, 2006, at 6:45 AM, [EMAIL PROTECTED] wrote: Please double-check your code. The error message "library routine called out of sequence" is what you get when you try to use the the same database connection from more than one thread at one time. If I remember correctly, there are two

Re: [sqlite] multi threats parallel reading db

Max <[EMAIL PROTECTED]> wrote: > Hi, > > I am running into problems with sqlite 3.3.6 when trying to read from a > database with multiple threats in parallel. Each threat has it's own > connection and i compiled sqlite with --enable-threadsafe. Still it will > throw exceptions if i don't keep the

[sqlite] multi threats parallel reading db

Hi, I am running into problems with sqlite 3.3.6 when trying to read from a database with multiple threats in parallel. Each threat has it's own connection and i compiled sqlite with --enable-threadsafe. Still it will throw exceptions if i don't keep the threats from accessing it in parellel.

Re: [sqlite] Re: Using Wrong Date Format

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

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

[sqlite] Using Wrong Date Format

Hi, 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. Can anyone help me with this, please? Regards, Eoin -- View this message in context:

[sqlite] need to form an frame work for database independent API

I wish to form an database independant API for sqlite and BerkeleyDB . I need to now wht factors should consider . i am new to both . I have problems in running an simple program in sqlite . its say can't find the sqlite3_open( . If i paste the source code for that funstion ,it say that some