Re: [INTERFACES] where did that date and time come from?? - Mailing list pgsql-interfaces

From Thomas Lockhart
Subject Re: [INTERFACES] where did that date and time come from??
Date
Msg-id 3720035D.1D8925BF@alumni.caltech.edu
Whole thread Raw
In response to where did that date and time come from??  (JT Kirkpatrick <jt-kirkpatrick@mpsllc.com>)
List pgsql-interfaces
> How about this?
> added datetime default datetime(now()) not null,

Yes, this apparently works by converting from timestamp to datetime.
In general datetime has better dynamic range than does timestamp, but
for calculating 'now' both are equivalent in performance.

                    - Tom

--
Thomas Lockhart                lockhart@alumni.caltech.edu
South Pasadena, California

pgsql-interfaces by date:

Previous
From: Michael Meskes
Date:
Subject: Re: [INTERFACES] ecpg cursors and scope
Next
From: "Shad Cool"
Date:
Subject: libpq++