Postgres Pro
Downloads
Home   >   mailing lists

function for current date-time - Mailing list pgsql-general

From Harpreet Dhaliwal
Subject function for current date-time
Date
Msg-id d86a77ef0610161156h1022b185i84676bcaff63b68@mail.gmail.com
Whole thread Raw
Responses Re: function for current date-time  (Bricklen Anderson <banderson@presinet.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>)
List pgsql-general
Tree view
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

pgsql-general by date:

Previous
From: "Harpreet Dhaliwal"
Date:
Subject: Re: difference b/w text and varchar datatypes
Next
From: Richard Broersma Jr
Date:
Subject: Re: difference b/w text and varchar datatypes