On 8/6/05, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > Brendan Jurd <direvus@xxxxxxxxx> writes: > > timeofday() returns text, and moreover it returns in a bizarre format > > which cannot be converted directly into any useful temporal types, at > > least not in 8.0.2: > > Hm? Works fine for me. What datestyle setting do you have exactly? > => show datestyle; DateStyle ----------- ISO, DMY ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend