Forum OpenACS Q&A: Re: Postgres to_date bug?

Collapse
8: Re: Postgres to_date bug? (response to 1)
Posted by Nima Mazloumi on
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