From: Jasmin Dizdarevic <jasmin.dizdarevic@gmail.com>
To: Gianvito Pio <pio.gianvito@gmail.com>
To: pgsql-sql@postgresql.org
Subject: Re: Timestamp with timezone with Default value
Date: Sat, 18 Jul 2009 12:25:06 +0200
Message-ID: <a0eee4d40907180325s2ac61859g71de0746825c28e2@mail.gmail.com> (raw)
In-Reply-To: <24F73F01AD1B4036A4C3F461ED6759CE@PCGianvito>
References: <24F73F01AD1B4036A4C3F461ED6759CE@PCGianvito>
Hi,
i think:
create. ...(
myCol timestamp with timezone default now()
)
the function now() returns a timestamp with timezone (
http://www.postgresql.org/docs/8.4/static/functions-datetime.html)
i currently have no db to test it - but it should work.
jasmin
2009/7/18 Gianvito Pio <pio.gianvito@gmail.com>
> Hi all,
> how can I define a column of timestamp with timezone type...with a default
> value?
>
> Thanks
>
>
--
Mit freundlichen Grüßen
Dizdarevic Jasmin
Sonnenbergstr. 3
6714 Nüziders, AUT
jasmin.dizdarevic@gmail.com
+43 664 411 79 29
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jasmin.dizdarevic@gmail.com, pio.gianvito@gmail.com
Subject: Re: Timestamp with timezone with Default value
In-Reply-To: <a0eee4d40907180325s2ac61859g71de0746825c28e2@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox