Stuart Green wrote:
select to_char(to_timestamp('2008-11-14 16:00:00','YYYY-MM-DD HH24:MM:SS'),'day');is returning monday as the day in all the dbase version I Have test, 8.2.11, 8.2.10, and 8.1.11
Use 'MI' instead of 'MM' for the minutes. to_timestamp is quite lenient, and interpretes the 00 in what you meant to be the minutes field as month number. As there is no month 0, it uses January.
to_timestamp is much stricter in the upcoming 8.4 release, and will throw an error for that query:
postgres=# select to_char(to_timestamp('2008-11-14 16:00:00','YYYY-MM-DD HH24:MM:SS'),'day');
ERROR: conflicting values for "MM" field in formatting string DETAIL: This value contradicts a previous setting for the same field type. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com -- Sent via pgsql-bugs mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
