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

Re: timestamp data type?

From: Nabil Sayegh <postgresql(at)e-trolley(dot)de>
To: Oliver Elphick <olly(at)lfix(dot)co(dot)uk>
Cc: psql novice <psql_novice(at)operamail(dot)com>,pgsql-novice <pgsql-novice(at)postgresql(dot)org>
Subject: Re: timestamp data type?
Date: 2003-05-22 17:16:13
Message-ID: 1053623773.611.9.camel@billy (view raw or flat)
Thread:
Lists: pgsql-novice
Am Don, 2003-05-22 um 17.03 schrieb Oliver Elphick:

> CREATE TABLE xxx (
>    ts TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
>    ...);

BTW: Is there a difference between DEFAULT now() and DEFAULT
CURRENT_TIMESTAMP ?

-- 
 e-Trolley Sayegh & John, Nabil Sayegh
 Tel.: 0700 etrolley /// 0700 38765539
 Fax.: +49 69 8299381-8
 PGP : www.e-trolley.de


In response to

pgsql-novice by date

Next:From: Tom LaneDate: 2003-05-22 17:46:56
Subject: Re: Problem on Linux
Previous:From: Nabil SayeghDate: 2003-05-22 17:13:51
Subject: Re: Problem on Linux

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