Skip site navigation (1) Skip section navigation (2)

Re: [INTERFACES] where did that date and time come from??

From: Thomas Lockhart <lockhart(at)alumni(dot)caltech(dot)edu>
To: chairudin(at)prima(dot)net(dot)id
Cc: JT Kirkpatrick <jt-kirkpatrick(at)mpsllc(dot)com>, "'pgsql-admin(at)hub(dot)org'" <pgsql-admin(at)hub(dot)org>, "'pgsql-interfaces(at)hub(dot)org'" <pgsql-interfaces(at)hub(dot)org>
Subject: Re: [INTERFACES] where did that date and time come from??
Date: 1999-04-23 05:21:33
Message-ID: 3720035D.1D8925BF@alumni.caltech.edu (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-interfacespgsql-sql
> 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(at)alumni(dot)caltech(dot)edu
South Pasadena, California

In response to

pgsql-sql by date

Next:From: Chairudin SentosaDate: 1999-04-23 08:30:05
Subject: Re: [SQL] Finding the "most recent" rows
Previous:From: Chris BitmeadDate: 1999-04-23 04:39:33
Subject: Re: [SQL] Finding the "most recent" rows

pgsql-interfaces by date

Next:From: Shad CoolDate: 1999-04-23 06:28:31
Subject: libpq++
Previous:From: Michael MeskesDate: 1999-04-23 04:16:06
Subject: Re: [INTERFACES] ecpg cursors and scope

pgsql-general by date

Next:From: dustin sallingsDate: 1999-04-23 06:17:45
Subject: Re: [GENERAL] 9k limit?
Previous:From: Simon DrabbleDate: 1999-04-23 01:06:02
Subject: Re: [GENERAL] 9k limit?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group