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:48:00 |
Message-ID: | 02d501c109a3$2492bc40$6401a8c0@mgflaptop |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Sorry... this isn't GMT.
----- Original Message -----
From: "Mark G. Franz" <mgfranz(at)pe(dot)net>
To: "suhail sarwar" <sarwar(at)postmaster(dot)co(dot)uk>; <pgsql-novice(at)postgresql(dot)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(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
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
>
From | Date | Subject | |
---|---|---|---|
Next Message | D. Duccini | 2001-07-11 00:53:08 | Re: Date/Time insertions in postgres |
Previous Message | Mark G. Franz | 2001-07-11 00:02:01 | Re: Date/Time insertions in postgres |