Re: timestamp default values

Brendan Jurd <direvus(at)gmail(dot)com> writes:
> On 8/6/05, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>> Brendan Jurd <direvus(at)gmail(dot)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