I have a problem with to_date as well:
I have a field in the database date of the type timestampz.
The field returns a string like this:
"2004-06-04 12:50:00+02"
Now if I call to_date(date, ('YYYY-MM-DD HH24:MI') this results in
"2004-06-04" and the hours and minutes are missing. Why is that? Is this a bug?
I am using PostgreSQL 7.3.4.
Greetings,
Nima