Luca Clementi <lclement@ucsd.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