Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 8BC2A2E037D for ; Thu, 31 Jan 2008 14:09:10 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 95407-07 for ; Thu, 31 Jan 2008 14:09:02 -0400 (AST) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id DC84D2E02EF for ; Thu, 31 Jan 2008 14:09:03 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.14.2/8.14.2) with ESMTP id m0VI9383010462; Thu, 31 Jan 2008 13:09:03 -0500 (EST) To: Luca Clementi cc: pgsql-sql@postgresql.org Subject: Re: Problem with the to_timestamp function In-reply-to: <47A20CAA.609@ucsd.edu> References: <47A10A1D.5020408@ucsd.edu> <27257.1201739170@sss.pgh.pa.us> <47A12CCB.1000807@ucsd.edu> <751.1201759441@sss.pgh.pa.us> <47A20CAA.609@ucsd.edu> Comments: In-reply-to Luca Clementi message dated "Thu, 31 Jan 2008 10:00:10 -0800" Date: Thu, 31 Jan 2008 13:09:03 -0500 Message-ID: <10461.1201802943@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200801/238 X-Sequence-Number: 30091 Luca Clementi writes: > What do you mean with th standard input converter, you mean casting that > string into a date with the default locate format. This won't work, > because the machine where the DB is running is set to en.US, so it won't > be able to parse that date. That's why I am using the to_timestamp. Locale has nothing to do with this --- at most you might want to adjust the datestyle parameter. regards, tom lane