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@libertyrms.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@libertyrms.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@postgresql.org)