Re: Date/Time insertions in postgres

From: "Mark G(dot) Franz" <mgfranz(at)pe(dot)net>
To: "suhail sarwar" <sarwar(at)postmaster(dot)co(dot)uk>, <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Date/Time insertions in postgres
Date: 2001-07-11 00:02:01
Message-ID: 01db01c1099c$b6b13720$6401a8c0@mgflaptop
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Try this;

INSERT INTO Registration(EntryDate) VALUES ("DATETIME(NOW()")

----- Original Message -----
From: "suhail sarwar" <sarwar(at)postmaster(dot)co(dot)uk>
To: <pgsql-novice(at)postgresql(dot)org>
Sent: Wednesday, July 04, 2001 2:56 AM
Subject: [NOVICE] Date/Time insertions in postgres

> Hi,
>
> I am developing a payment system and am using postgres to store all the
transactions so that they can be tracked.
> Is there a way of adding the date and time in GMT to a column everytime an
insert command is issued from within a java program ?
>
> Any input would be appreciated.
>
> Regards
>
> Suhail Sarwar
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Mark G. Franz 2001-07-11 00:48:00 Re: Date/Time insertions in postgres
Previous Message Baer Peter 2001-07-10 08:50:01 Re: Postgres and Linux 7.1