Hello
In this version I can't convert returned value to time. timeofday() return
text. I need convert to timestamp before. It is normal behavior? I
expected timestamp as returned type.
regards
Pavel Stehule
---(end of broadcast)---
TIP 8: expla
On Fri, 8 Aug 2003, Pavel Stehule wrote:
> In this version I can't convert returned value to time. timeofday() return
> text. I need convert to timestamp before. It is normal behavior? I
> expected timestamp as returned type.
It is documented to return a string for historical reasons:
http://w
Pavel Stehule <[EMAIL PROTECTED]> writes:
>> You probably want now() instead of that function.
> I can't use now() or others because I need actual time in transaction.
Just cast the result of timeofday() to timestamp (with time zone, likely).
regards, tom lane
--
