Brendan Jurd <direvus@gmail.com> writes:
> On 8/6/05, Tom Lane <tgl@sss.pgh.pa.us> wrote:
>> Brendan Jurd <direvus@gmail.com> 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
Well, it works just fine here.
regression=# set datestyle = iso,dmy;
SET
regression=# select timeofday();
timeofday
-------------------------------------
Sat Aug 06 10:00:45.791921 2005 EDT
(1 row)
regression=# select timeofday()::timestamp;
timeofday
----------------------------
2005-08-06 10:00:47.920636
(1 row)
I'm testing 8.0 branch tip (or nearly so), not 8.0.2, but I don't see
any related bug fixes in the CVS logs. And this is something that's
always worked in the past --- else we'd have been more motivated to
change timeofday()'s behavior.
Is it possible you have a broken build? Any nondefault configure
options?
Can anyone else duplicate the problem?
regards, tom lane