Joe Conway wrote: > Is this what you wanted? > > regression=# select to_char(timestamp(0) '2003-10-24 > 15:30:59.999','YYYYMMDDHH24MISS'); > to_char > ---------------- > 20031024153100 > (1 row)
Yes! Exactly! > > See: > http://www.postgresql.org/docs/current/static/datatype-datetime.html Shame on me. I've must read that page more times than I can remember. I never realized that I could use the precision qualifier to do a cast (and round): comp_20031117=> create table ts (ts timestamp without time zone); CREATE TABLE comp_20031117=> insert into ts values ('2003-10-24 15:30:59.999'); INSERT 406299 1 comp_20031117=> select * from ts; ts ------------------------- 2003-10-24 15:30:59.999 (1 row) comp_20031117=> select to_char (ts ::timestamp(0), 'YYYYMMDDHH24MISS') from ts; to_char ---------------- 20031024153100 (1 row) thank you very much Joe cl. PS. Alvaro, your solution was what I was implementing already, but yes it's ugly, that's why I gave it a second round. Thanks anyway. ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html