Re: now() more precise than the transaction

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: now() more precise than the transaction
Date: 2003-02-04 20:49:37
Message-ID: 20030204154937.U3632@mail.libertyrms.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2003-02-04 21:05:58 Re: not exactly a bug report, but surprising behaviour
Previous Message Greg Stark 2003-02-04 20:39:13 Re: now() more precise than the transaction