John DeSoi wrote:
>
> On Apr 20, 2005, at 6:15 PM, Christopher J. Bottaro wrote:
>
>> I understand that CURRENT_TIMESTAMP marks the beginning of the current
>> transaction. I want it to be the actual time. How do I do this?
>> timeofday() returns a string, how do I convert that into a TIMESTAMP?
>
>
> timeofday()::timestamp;
Great, that did it, thanks. I also found out that you can say
CAST(timeofday() AS TIMESTAMP). I assume its the same thing...
-- C
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
