Thread

1. Date/Time insertions in postgres

   suhail sarwar <sarwar@postmaster.co.uk> — 2001-07-04T09:56:14Z

   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
   
   

2. Re: Date/Time insertions in postgres

   Mark G. Franz <mgfranz@pe.net> — 2001-07-11T00:02:01Z

   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
   >
   
   
   

3. Re: Date/Time insertions in postgres

   Mark G. Franz <mgfranz@pe.net> — 2001-07-11T00:48:00Z

   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
   >
   
   
   

4. Re: Date/Time insertions in postgres

   D. Duccini <duccini@backpack.com> — 2001-07-11T00:53:08Z

   
   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!"   
   -----------------------------------------------------------------------------