From: Seb <nospam@nospam.net>
To: pgsql-sql@postgresql.org
Subject: Date/Time types
Date: Fri, 20 Sep 2002 10:54:55 +0200
Message-ID: <amenp5$1mtv$1@news.hub.org> (raw)
Hello,
I'm french, so excuse me if my english is not correct.
I'd like to create a table with a Timestamp row (named date for example) and
width a resolution as smaller as possible (1 microsecond if possible).
What is exactly the correct query for that question ?
The query I've written is :
CREATE TABLE "table" (
"id" int4 NOT NULL,
"date" timestamp [13] NOT NULL )
If this correct, I've a second question : how can I insert a value ??? I've
tried many ways but any works ! I'm lost....
I've tried to cast, to use CURRENT_TIMESTAMP with a precision, but nothing
works...
Thanks for your help
Seb
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: nospam@nospam.net
Subject: Re: Date/Time types
In-Reply-To: <amenp5$1mtv$1@news.hub.org>
* 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