Re: now() more precise than the transaction - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: now() more precise than the transaction
Date
Msg-id 20030204154937.U3632@mail.libertyrms.com
Whole thread Raw
In response to Re: now() more precise than the transaction  (Greg Stark <gsstark@mit.edu>)
List pgsql-general
On Tue, Feb 04, 2003 at 03:39:13PM -0500, Greg Stark wrote:
> timeofday appears to return text though. Do I just assume it will
> always cast cleanly to a timestamp? It doesn't seem to be in the
> same format as timestamps print though.

But it does come out in a format that the timestamp input can accept.
It shouldn't be a problem to cast it to timestamp.

A

----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110


pgsql-general by date:

Previous
From: Greg Stark
Date:
Subject: Re: now() more precise than the transaction
Next
From: Stephan Szabo
Date:
Subject: Re: not exactly a bug report, but surprising behaviour