Re: Date/Time insertions in postgres
От | Mark G. Franz |
---|---|
Тема | Re: Date/Time insertions in postgres |
Дата | |
Msg-id | 01db01c1099c$b6b13720$6401a8c0@mgflaptop обсуждение исходный текст |
Ответ на | Date/Time insertions in postgres ("suhail sarwar" <sarwar@postmaster.co.uk>) |
Ответы |
Re: Date/Time insertions in postgres
|
Список | 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 по дате отправления: