Mark Morgan Lloyd <markMLl.pgsql-general@xxxxxxxxxxxxxxx> schrieb: > > test=# select now()::time; > > now > > ---------------- > > 11:16:18.22527 > > (1 row) > > Thanks Andreas, I've ended up using CAST( ... AS TIME). I think the :: notation > might be fragile in this instance because of the machine-generated SQL which Thats okay, because my version (the ::cast) is a PostgreSQL-feature, but the cast(... as ...) is more SQL-conform. Andreas -- Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. (Linus Torvalds) "If I was god, I would recompile penguin with --enable-fly." (unknow) Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°
