Re: Datetime

From: Michael Glaesemann <grzm(at)myrealbox(dot)com>
To: "Pedro B(dot)" <pedro(dot)borracha(at)netcabo(dot)pt>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Datetime
Date: 2004-08-03 10:56:56
Message-ID: D5FEB818-E53B-11D8-8966-000A95C88220@myrealbox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

  • Datetime at 2004-08-03 07:22:51 from Pedro B.

Browse pgsql-sql by date

  From Date Subject
Next Message Devrim GUNDUZ 2004-08-03 10:58:26 Re: Datetime
Previous Message Achilleus Mantzios 2004-08-03 10:23:14 Re: Datetime