[GENERAL] select query on Dates stored as varchar

2010-08-30 Thread Yosef Haas
sion does not seem to know that '2010-06-24' is a date the same way that '20100624' is. Any ideas? Is there somewhere that I can specify that with, or without the hyphens, they are both dates? Thank you, Yosef Haas yo...@karatedepot.com

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

2010-08-30 Thread Yosef Haas
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. Thanks, Yosef Haas yo...@karatedepot.com -Original Message- F

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

2010-08-30 Thread Yosef Haas
point me in the right direction to making this work the way it did. The answer was the locale. Once I did initdb with --locale=en_US.UTF-8 it worked. I know this is not great for the long run, but right now I need to get this up and running. Thanks for the help. Yosef Haas yo...@karatedepot.com