On Wed, 3 Apr 2002, Chris Pesko wrote:
> Never mind. Just figured it out. Need to grab the substring from 2 for 8 > from the to_char result because it holds character number 1 reserv ed for + > or - signs. + is default or white space. I think that is the reason. Any > other input????? You might want to try the FM format on the to_char string... sszabo=# select to_date(to_char(20020101, 'FM99999999'),'yyyymmdd'); to_date ------------ 2002-01-01 (1 row) ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
