Re: Problem with Now()?

From: "Linn Kubler" <LKubler(at)ecw(dot)org>
To: < <pgsql-general(at)postgresql(dot)org>>
Subject: Re: Problem with Now()?
Date: 2002-08-15 16:04:05
Message-ID: sd5b8ac3.011@gw1.inet.ecw.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ok, here's what I've done and so far it seems to be working. I found
another function called current_timestamp which allows a parameter for
setting the precision. So I changed the default value to set a
precision of zero and it seems to be happy again. If anyone has a more
elegant solution I all ears :-)

Thanks for helping me find a solution.
Linn

>>> Andrew Sullivan <andrew(at)libertyrms(dot)info> 08/15/02 09:39AM >>>
On Thu, Aug 15, 2002 at 09:28:28AM -0500, Linn Kubler wrote:

> productid | title | datecreated
> -----------+---------------------+-------------------------------
> 428 | Zebra Test Record 1 | 2002-08-15 09:13:33.684448-05

That looks fine. The date and time created was 15 August 2002 at
9:13:33.684448 am in a time zone 5 hours behind UTC (I guess that's
CDT?). The ".684448" is fractional seconds. IIRC, fractional
seconds are supported for the first time in 7.2.

A

----
Andrew Sullivan 87 Mowat Avenue
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M6K 3E3
+1 416 646 3304 x110

---------------------------(end of
broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to
majordomo(at)postgresql(dot)org)

Browse pgsql-general by date

  From Date Subject
Next Message Linn Kubler 2002-08-15 16:05:35 Re: Problem with Now()?
Previous Message Tom Lane 2002-08-15 15:52:35 Re: pgaccess error message