you can store you dates like integers using time(). So you can use strftme
without any string operation.
[]'s
Victor
Lawrence Chitty <[EMAIL PROTECTED]> escreveu:
DuenosEnLaWEB.com.ar wrote:
>hi
>
>I have this format for dates: mmdd
>I want this format to be returned from a query: dd/mm/yy
DuenosEnLaWEB.com.ar wrote:
hi
I have this format for dates: mmdd
I want this format to be returned from a query: dd/mm/
The only way i have found is doing this... but i do not like it very =
much
SELECT =
strftime('%d/%m/%Y',substr('20050605',1,4)||'-'||substr('20050605',5,2)||=
'-'|
Duh! :-))
Thanks!
--- "D. Richard Hipp" <[EMAIL PROTECTED]> wrote:
> On Wed, 2005-08-31 at 15:46 -0700, Clark Christensen
> wrote:
> > Using Sqlite v3.2.5 on both Linux, and Windows, I'm
> having
> > some difficulty reconciling unixepoch seconds with
> other
> > tools. Consider this:
> >
> >
Clark Christensen wrote:
Using Sqlite v3.2.5 on both Linux, and Windows, I'm having
some difficulty reconciling unixepoch seconds with other
tools. Consider this:
select strftime('%s', '2005-08-30 15:19:00');
returns 1125415140
This is the UTC time (sort of the same as GMT I think). You pr
On Wed, 2005-08-31 at 15:46 -0700, Clark Christensen wrote:
> Using Sqlite v3.2.5 on both Linux, and Windows, I'm having
> some difficulty reconciling unixepoch seconds with other
> tools. Consider this:
>
> select strftime('%s', '2005-08-30 15:19:00');
>
> returns 1125415140
>
> If I take that
hi
I have this format for dates: mmdd
I want this format to be returned from a query: dd/mm/
The only way i have found is doing this... but i do not like it very =
much
SELECT =
strftime('%d/%m/%Y',substr('20050605',1,4)||'-'||substr('20050605',5,2)||=
'-'||substr('20050605',7,2));
is t
> 2005-08-30 15:19:00
> 2005-08-30 08:19:00
Your time zone is -7. Read the SQLite docs to see how
to convert between local time and UTC (they're in the
wiki).
Regards
Would this be covered by the change in
http://www.sqlite.org/cvstrac/tktview?tn=1216 and its
related check-in?
--- Clark Christensen <[EMAIL PROTECTED]> wrote:
> Using Sqlite v3.2.5 on both Linux, and Windows, I'm
> having
> some difficulty reconciling unixepoch seconds with other
> tools. Consi
Using Sqlite v3.2.5 on both Linux, and Windows, I'm having
some difficulty reconciling unixepoch seconds with other
tools. Consider this:
select strftime('%s', '2005-08-30 15:19:00');
returns 1125415140
If I take that resulting value and feed it to localtime()
in Perl, either under Windows or L
> This works on some systems but not on others. On some
> versions of Linux, a thread is not able to override locks
> created by a different thread in the same process. When
> that happens, a database connection created on one thread
> will not be usable by a different thread.
This is not the po
Hello,
Is this the only reason for the...
"database handle can only be used on the same thread
that opened it"
...rule? Does Windows have that issue?
If so, can we convert this to a compile time option?
Eg. OS_SUPPORTS_THREADSAFE_FILE_LOCKS or similar
flag which can be set to true for OSes whi
Hi,
How can I use an index to search for null and non-null values?
I have the following table (with one million rows):
CREATE TABLE tbl (id string primary key unique, time);
CREATE INDEX time_ind on tbl(time);
It seems that:
select * from tbl where id notnull;
does not use an index and takes a
On Wed, 2005-08-31 at 12:53 +0200, Guillaume Fougnies wrote:
> My code is sharing a pool of SQLite connections on
> multiple databases between a bunch of treatment
> threads.
> Each thread pops a connection from the pool safely
> and push it back once finished.
>
This works on some systems but no
To avoid unintentionally finding indexes with the given name, you
should use:
select * from sqlite_master where type = 'table' and name = 'TABLENAME'
-Tom
> -Original Message-
> From: Sergey Startsev [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, August 31, 2005 7:35 AM
> To: Mass
Hello Massimo,
Wednesday, August 31, 2005, 7:19:27 PM, you wrote:
MG> Is there any way to check if a table (in an opened database) exists?
MG> Something smarter than "SELECT * FROM TABLENAME". ?
Select * from sqlite_master where name = 'TABLENAME'
--
Best regards
Sergey Startsev
SQLite Ana
Dear all,
Is there any way to check if a table (in an opened database) exists?
Something smarter than "SELECT * FROM TABLENAME". ?
The query should be carried out without any info about the table contents.
Regards
Max
Hello,
After an upgrade from sqlite 3.2.2 to 3.2.5, i got problems
with strange SQLITE_MISUSE returns.
After a little investigation, i found it was the
--enable-threadsafe option correction in Check-In 2623.
It seems SQLite, in os_unix.c sqlite3OsLock with the
SQLITE_UNIX_THREADSAFE flag (correct
On 8/31/05, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> I would like to know if it is possible to have an instance of sqlite
> running in RAM only? My aim is to build a small but fast memory SQL
> storage.
How about using the database called ":memory:". Unless this has been
removed when I wasn'
Thanks guys I will investigate those features.
Benjamin Filippi
Capital Fund Management
6 boulevard Haussmann 75009 Paris
Tel: +33 1 49 49 59 30
Fax: +33 1 47 70 17 40
[EMAIL PROTECTED]
http://www.cfm.fr
Ben Clewett <[EMAIL PROTECTED]>
08/31/2005 10:41 AM
Please respond to sqlite-users
Benjamin,
This works well on Linux using file system /dev/shm. This should be
installed as default and works indistinguishably from normal file
system. SQLite writes about 200 times faster than normal file system.
Remember that like all ram disks, this is wiped without warning on
shut-down
Salut Benjamin,
Simplest way to make that happen is to use a ram disk, google for 'RamDisk'
and the platform you are using. Then you can use the existing sqlite
binary/library but all I/O occurs in memory.
When you want to persist, you just copy it to a hard disk...
D.
Hi,
I would like to know if it is possible to have an instance of sqlite
running in RAM only? My aim is to build a small but fast memory SQL
storage.
Thanks.
Benjamin Filippi
Capital Fund Management
6 boulevard Haussmann 75009 Paris
Tel: +33 1 49 49 59 30
Fax: +33 1 47 70 17 40
[EMAIL PROTECTE
22 matches
Mail list logo