Re: function for current date-time

Поиск
Список
Период
Сортировка
Искать
От
Reid Thompson
Тема
Re: function for current date-time
Дата
Msg-id
1161025404.5517.2.camel@jhereg
Ответ на
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>
On Mon, 2006-10-16 at 14:56 -0400, Harpreet Dhaliwal wrote:
> 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?
> 
> Thanks,
> ~Harpreet 

test=# select now();
              now              
-------------------------------
 2006-10-16 15:03:13.174644-04
(1 row)

В списке pgsql-general по дате отправления
От: Vivek Khera
Дата:
Сообщение: Re: old Pg interface
От: Carlos H. Reimer
Дата:
Сообщение: RES: RES: Dates rejected
FAQ