Re: [sqlite] Converting date from d/m/yy format

2007-11-02 Thread John Stanton
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. Over the years we

Re: [sqlite] Converting date from d/m/yy format

2007-11-02 Thread Daniel Önnerby
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 people try to process

Re: [sqlite] Converting date from d/m/yy format

2007-11-02 Thread John Stanton
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 the most unholy

RE: [sqlite] Converting date from d/m/yy format

2007-11-02 Thread 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 is a blind spot

Re: [sqlite] Converting date from d/m/yy format

2007-11-02 Thread John Stanton
___ -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

RE: [sqlite] Converting date from d/m/yy format

2007-11-02 Thread Lee Crain
[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

Re: [sqlite] Converting date from d/m/yy format

2007-11-02 Thread John Stanton
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

Re: [sqlite] Converting date from d/m/yy format

2007-11-02 Thread Kees Nuyt
[Default] On Fri, 2 Nov 2007 17:29:23 +1100, T <[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

RE: [sqlite] Converting date from d/m/yy format

2007-11-02 Thread Lee Crain
CTED] 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, where: d = day

Re: [sqlite] Converting date from d/m/yy format

2007-11-02 Thread John Stanton
T 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

Re: [sqlite] Converting date from d/m/yy format

2007-11-02 Thread T
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

Re: [sqlite] Converting date from d/m/yy format

2007-11-02 Thread T
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

Re: [sqlite] Converting date from d/m/yy format

2007-11-02 Thread John Stanton
T 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

Re: [sqlite] Converting date from d/m/yy format

2007-11-02 Thread Gerry Snyder
T 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

[sqlite] Converting date from d/m/yy format

2007-11-01 Thread T
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,