Re: Problem with the to_timestamp function

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

Luca Clementi <lclement(at)ucsd(dot)edu> 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