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

Re: [GENERAL] current_timestamp and default now()

From: Lincoln Yeoh <lylyeoh(at)mecomb(dot)com>
To: "amy cheng" <amycq(at)hotmail(dot)com>, pgsql-general(at)postgreSQL(dot)org
Subject: Re: [GENERAL] current_timestamp and default now()
Date: 1999-10-26 01:07:51
Message-ID: 3.0.5.32.19991026090751.008be900@pop.mecomb.po.my (view raw or flat)
Thread:
Lists: pgsql-general
At 01:05 PM 25-10-1999 PDT, amy cheng wrote:
>hi, there,
>
>I'm using:
>
>create table test (
>proposetime   datetime not null default now(),
>)
>
>then, I find that I need to make the time uniform through the
>transaction. Is there a way to use current_timestamp('now')
>in the create table statement? Seems impossible?

How about reading off the current time (select <somethingblahblah> 'now', I
can't remember how to do it- not very obvious at first sight) and then
using that time throughout the transaction?

Cheerio,

Link.


In response to

Responses

pgsql-general by date

Next:From: Vadim MikheevDate: 1999-10-26 02:00:24
Subject: Re: [HACKERS] Re: [GENERAL] Postgres INSERTs much slower than MySQL?
Previous:From: Tatsuo IshiiDate: 1999-10-26 00:59:49
Subject: Re: [HACKERS] Re: [GENERAL] Postgres INSERTs much slower than MySQL?

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