Thread: function for current date-time

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

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

http://www.postgresql.org/docs/8.1/interactive/functions-datetime.html#FUNCTIONS-DATETIME-CURRENT

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)

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

XimpleWare released Version 1.7 of VTD-XML, the next generation XML
parser that goes beyond DOM and SAX, under GPL. VTD-XML is getting
faster, leaner, more stable and complete with this release. New features
included in this releases are:

* Additional XPath functions support
* Union Expression
* A rewritten VTDNav implementation
* Various bug fixes in VTDGen and XPath evaluation

Please visit http://vtd-xml.sf.net for the latest release.


For further reading, please refer to the following articles:
a.. Simplify XML Processing with VTD-XML
a.. Cut, Paste, Assemble and Split XML files with VTD-XML
a.. XML on a Chip
a.. Process Large XML Files with VTD-XML
a.. The performance Woe of Binary XML
a.. VTD-XML: The Next Generation XML Parser