RB Smissaert wrote:
Analyzing the lookup table knocks the time down from 0.36 to 0.31 secs,
something I didn't expect.
That shows the importance of testing. I ported the SQLite benchmarks to
Python and was surprised to see some of the tests taking minutes to run
versus a few (or a few tens of
RB Smissaert wrote:
Yes, it looks it isn't there.
I guess it isn't really SQLite's place to know how to spell this month's
name in your locale. It's a presentation issue at the end of the day and
a lookup table is a nice easy solution.
to update the table and 25000 records takes about a th
Analyzing the lookup table knocks the time down from 0.36 to 0.31 secs,
something I didn't expect.
RBS
-Original Message-
From: RB Smissaert [mailto:[EMAIL PROTECTED]
Sent: 18 February 2007 19:59
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] Month string from yyyy-mm-dd
Than
, but
I somehow guess it will be slower.
RBS
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: 18 February 2007 19:37
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Month string from yyyy-mm-dd
"RB Smissaert" <[EMAIL PROTECTED]> wrote:
> Is i
"RB Smissaert" <[EMAIL PROTECTED]> wrote:
> Is it possible with the date-time functions to get the month as a string, so
> January etc. from the date in the format -mm-dd?
This is difficult to internationalize so I omitted it in my
implementation of the date/time functions. You can, of course
users@sqlite.org
Subject: Re: [sqlite] Month string from yyyy-mm-dd
RB Smissaert wrote:
> Is it possible with the date-time functions to get the month as a string,
so
> January etc. from the date in the format -mm-dd?
Doesn't look like it. Nothing in the wiki and I couldn't see an
RB Smissaert wrote:
Is it possible with the date-time functions to get the month as a string, so
January etc. from the date in the format -mm-dd?
Doesn't look like it. Nothing in the wiki and I couldn't see anything in
the source either. I suppose you could use a big case statement if you
7 matches
Mail list logo
