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 14:51:35
Message-ID: sd5b79b6.096@gw1.inet.ecw.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ok, thanks. Is it possible to turn that feature off?
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)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Carmen Wai 2002-08-15 15:01:41 Re: Bulk row fetching
Previous Message Martijn van Oosterhout 2002-08-15 14:44:58 Re: Bulk row fetching