Re: Datetime - Mailing list pgsql-sql

From Michael Glaesemann
Subject Re: Datetime
Date
Msg-id D5FEB818-E53B-11D8-8966-000A95C88220@myrealbox.com
Whole thread Raw
In response to Datetime  ("Pedro B." <pedro.borracha@netcabo.pt>)
List pgsql-sql
On Aug 3, 2004, at 4:22 PM, Pedro B. wrote:

> Is it possible to make it something like 'yyyy-mm-dd hh:mm:ss:cc' ? 
> (basically, a DATE and a TIME, but with 2 decimal cases on the :cc and 
> not .ccccc as the TIME format.

timestamp and timestamptz both take an optional precision parameter. 
What you want is timestamp(2) or timestamptz(2), I believe.

Michael Glaesemann
grzm myrealbox com



pgsql-sql by date:

Previous
From: "Pedro B."
Date:
Subject: Datetime
Next
From: Devrim GUNDUZ
Date:
Subject: Re: Datetime