Hi Kees and John,
If you are getting data and storing it in an Sqlite database why not
store it in the appropriate format?
I will be storing it in the appropriate format. That's the objective
of this solution, to convert the data into the appropriate format. I
just want to do it within SQ
-Original Message-
From: John Stanton [mailto:[EMAIL PROTECTED] Sent: Monday,
December 03, 2007 12:55 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Converting date from d/m/yy format
I didn't mean to nitpick, but my experience has been that date and
time processing is a blind spot
cember 03, 2007 12:55 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Converting date from d/m/yy format
I didn't mean to nitpick, but my experience has been that date and
time processing is a blind spot. Over the years we have come across
the most unholy kludges and nasty errors as p
lto:[EMAIL PROTECTED]
Sent: Monday, December 03, 2007 12:55 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Converting date from d/m/yy format
I didn't mean to nitpick, but my experience has been that date and time
processing is a blind spot. Over the years we have come across t
Lee Crain
-Original Message-
From: John Stanton [mailto:[EMAIL PROTECTED]
Sent: Monday, December 03, 2007 12:55 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Converting date from d/m/yy format
I didn't mean to nitpick, but my experience has been that date and time
processing
Crain
___
-Original Message-
From: John Stanton [mailto:[EMAIL PROTECTED]
Sent: Monday, December 03, 2007 12:18 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Converting date from d/m/yy format
That approach makes date processing clumsy. Distributing dates across
time zones and
[mailto:[EMAIL PROTECTED]
Sent: Monday, December 03, 2007 12:18 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Converting date from d/m/yy format
That approach makes date processing clumsy. Distributing dates across
time zones and into different calendars is difficult. Date arithmetic
is
Lee Crain wrote:
Several years ago when I worked for a Fortune 70 company, we had a server
whose source code and database were complicated by timestamps. I say
complicated because there were different timestamp datatypes used for
different fields (inherited from the data sources), the data could
[Default] On Fri, 2 Nov 2007 17:29:23 +1100, T&B
<[EMAIL PROTECTED]> wrote:
>Hi all,
>
>How can I convert dates from the format d/m/yy to SQL style YYY-MM-DD?
>
>I have some imported data that includes a date column in the format d/
>m/yy, where:
>
>d = day as 1 or two digits
>m = month as 1 or
AIL PROTECTED]
Sent: Friday, November 02, 2007 12:29 AM
To: sqlite-users@sqlite.org
Subject: [sqlite] Converting date from d/m/yy format
Hi all,
How can I convert dates from the format d/m/yy to SQL style YYY-MM-DD?
I have some imported data that includes a date column in the format d/
m/yy,
T&B wrote:
Hi John,
How can I convert dates from the format d/m/yy to SQL style YYY-MM- DD?
The data is from a bank, so I have no control over its production.
I couldn't find any suitable built in SQLite functions, which all
seem to operate in the other direction.
If you transform
Hi Gerry,
I would suggest either [scan] or [regexp] , with the former probably
being easier.
I'd love to use RegExp, but SQLite doesn't include it in its standard
functions (though I wish it did for so many reasons). I'm not familiar
with scan.
Tom
Hi John,
How can I convert dates from the format d/m/yy to SQL style YYY-MM-
DD?
The data is from a bank, so I have no control over its production.
I couldn't find any suitable built in SQLite functions, which all
seem to operate in the other direction.
If you transform the date i
T&B wrote:
Hi all,
How can I convert dates from the format d/m/yy to SQL style YYY-MM-DD?
I have some imported data that includes a date column in the format d/
m/yy, where:
d = day as 1 or two digits
m = month as 1 or two digits
yy = year as two digits
eg:
2/11/07 = today
2/8/68 = 2nd
T&B wrote:
Hi all,
How can I convert dates from the format d/m/yy to SQL style YYY-MM-DD?
I would suggest either [scan] or [regexp] , with the former probably
being easier.
Gerry
-
To unsubscribe, send email to [
Hi all,
How can I convert dates from the format d/m/yy to SQL style YYY-MM-DD?
I have some imported data that includes a date column in the format d/
m/yy, where:
d = day as 1 or two digits
m = month as 1 or two digits
yy = year as two digits
eg:
2/11/07 = today
2/8/68 = 2nd of August, 1
16 matches
Mail list logo