Re: Datetime

From: Devrim GUNDUZ <devrim(at)gunduz(dot)org>
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:58:26
Message-ID: Pine.LNX.4.44.0408031358110.24680-100000@emo.org.tr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql


Hi,

On Tue, 3 Aug 2004, Pedro B. wrote:

> I'm using a TIMESTAMP column with a now() default which (correctly i
> assume) uses a 'yyyy-mm-dd hh:mm:ss' format.
>
> 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.

Is this what you are asking?

test=> SELECT now()::timestamp(1);
now
------------------------
2004-08-03 13:58:48.60
(1 row)

Regards,
--
Devrim GUNDUZ
devrim~gunduz.org devrim.gunduz~linux.org.tr
http://www.tdmsoft.com
http://www.gunduz.org

In response to

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

Browse pgsql-sql by date

  From Date Subject
Next Message Michael Glaesemann 2004-08-03 11:31:11 Re: Datetime
Previous Message Michael Glaesemann 2004-08-03 10:56:56 Re: Datetime