Postgres Pro
Downloads
Home   >   mailing lists

Thread: Date/Time insertions in postgres

Date/Time insertions in postgres

From
"suhail sarwar"
Date:
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

Re: Date/Time insertions in postgres

From
"Mark G. Franz"
Date:
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
>

Re: Date/Time insertions in postgres

From
"Mark G. Franz"
Date:
Sorry... this isn't GMT.

----- Original Message -----
From: "Mark G. Franz" <mgfranz@pe.net>
To: "suhail sarwar" <sarwar@postmaster.co.uk>; <pgsql-novice@postgresql.org>
Sent: Tuesday, July 10, 2001 5:02 PM
Subject: Re: [NOVICE] Date/Time insertions in postgres


> 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
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>

Re: Date/Time insertions in postgres

From
"D. Duccini"
Date:

or

insert into registration (entrydate) values ('now'::datetime);

-duck

On Tue, 10 Jul 2001, Mark G. Franz wrote:

> 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
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>


-----------------------------------------------------------------------------
david@backpack.com            BackPack Software, Inc.        www.backpack.com
+1 651.645.7550 voice       "Life is an Adventure.
+1 651.645.9798 fax            Don't forget your BackPack!"
-----------------------------------------------------------------------------