Re: Date/Time insertions in postgres - Mailing list pgsql-novice

From Mark G. Franz
Subject Re: Date/Time insertions in postgres
Date
Msg-id 01db01c1099c$b6b13720$6401a8c0@mgflaptop
Whole thread Raw
In response to Date/Time insertions in postgres  ("suhail sarwar" <sarwar@postmaster.co.uk>)
Responses Re: Date/Time insertions in postgres
List pgsql-novice
Try this;

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

----- Original Message -----
From: "suhail sarwar" <sarwar@postmaster.co.uk>
To: <pgsql-novice@postgresql.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
>


pgsql-novice by date:

Previous
From: R Vijayanath
Date:
Subject: can we write to a flat file from Postgresql procedure
Next
From: "Mark G. Franz"
Date:
Subject: Re: Date/Time insertions in postgres