Re: [GENERAL] select query on Dates stored as varchar

2010-08-30 Thread Yosef Haas
-Original Message- From: Jeff Davis [mailto:pg...@j-davis.com] Sent: Monday, August 30, 2010 5:23 PM To: Yosef Haas Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] select query on Dates stored as varchar On Mon, 2010-08-30 at 16:32 -0400, Yosef Haas wrote: > I have a table (tra

Re: [GENERAL] select query on Dates stored as varchar

2010-08-30 Thread Jeff Davis
On Mon, 2010-08-30 at 16:32 -0400, Yosef Haas wrote: > I have a table (transactions) with an order_date field that is > varchar(32). The data looks like this: > > > > order_date > > --- > > 20100623 02:16:40 > > 20100623 04:32:41 > > 20100625 04:18:53 > > 20100625 07:53

Re: [GENERAL] select query on Dates stored as varchar

2010-08-30 Thread Pavel Stehule
t; -Original Message- > From: Pavel Stehule [mailto:pavel.steh...@gmail.com] > Sent: Monday, August 30, 2010 4:45 PM > To: Yosef Haas > Cc: pgsql-general@postgresql.org > Subject: Re: [GENERAL] select query on Dates stored as varchar > > Hello > > 2010/8/30 Yosef Haas : &

Re: [GENERAL] select query on Dates stored as varchar

2010-08-30 Thread Pavel Stehule
2010/8/30 Scott Marlowe : > On Mon, Aug 30, 2010 at 2:53 PM, Yosef Haas wrote: >> I know it would be best to change the data type of the column (I didn't >> initially create the table), but doing so would be require changes to >> several application that use it and I'd like to avoid that if possib

Re: [GENERAL] select query on Dates stored as varchar

2010-08-30 Thread Scott Marlowe
On Mon, Aug 30, 2010 at 2:53 PM, Yosef Haas wrote: > I know it would be best to change the data type of the column (I didn't > initially create the table), but doing so would be require changes to > several application that use it and I'd like to avoid that if possible. 1. Most of those changes w

Re: [GENERAL] select query on Dates stored as varchar

2010-08-30 Thread Yosef Haas
rom: Pavel Stehule [mailto:pavel.steh...@gmail.com] Sent: Monday, August 30, 2010 4:45 PM To: Yosef Haas Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] select query on Dates stored as varchar Hello 2010/8/30 Yosef Haas : > I have a table (transactions) with an order_date field that

Re: [GENERAL] select query on Dates stored as varchar

2010-08-30 Thread Pavel Stehule
Hello 2010/8/30 Yosef Haas : > I have a table (transactions) with an order_date field that is varchar(32). > The data looks like this: > > > >     order_date > > --- > > 20100623 02:16:40 > > 20100623 04:32:41 > > 20100625 04:18:53 > > 20100625 07:53:24 > > > > In my current databa

[GENERAL] select query on Dates stored as varchar

2010-08-30 Thread Yosef Haas
I have a table (transactions) with an order_date field that is varchar(32). The data looks like this: order_date --- 20100623 02:16:40 20100623 04:32:41 20100625 04:18:53 20100625 07:53:24 In my current database (8.1.4) if I run select (*) from transactions where