Re: function for current date-time
От
A. Kretschmer
Тема
Re: function for current date-time
Дата
Msg-id
20061016191715.GA12075@a-kretschmer.de
Ответ на
function for current date-time (Harpreet Dhaliwal)
Список
Дерево обсуждения
function for current date-time "Harpreet Dhaliwal" <harpreet.dhaliwal01@gmail.com>
Re: function for current date-time Reid Thompson <Reid.Thompson@ateb.com>
Re: function for current date-time "A. Kretschmer" <andreas.kretschmer@schollglas.com>
Re: function for current date-time Bricklen Anderson <banderson@presinet.com>
am Mon, dem 16.10.2006, um 14:56:27 -0400 mailte Harpreet Dhaliwal folgendes: > Hi, > I have a timestamp field in my table and want to set a default value of current > date/time for it. > What should i enter as its default value? is there any function like now() in > postgres? Yes, now() ;-) test=# create table foo (id int, ts timestamp default now()); CREATE TABLE test=# insert into foo (id, ts) values (1, default); INSERT 0 1 test=# select * from foo; id | ts ----+--------------------------- 1 | 2006-10-16 21:18:15.75039 (1 row) Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47215, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net
В списке pgsql-general по дате отправления
