Home > mailing lists

Datetime - Mailing list pgsql-sql

From	Pedro B.
Subject	Datetime
Date	August 3, 2004 10:45:45
Msg-id	410F3D4B.60405@netcabo.pt Whole thread Raw
In response to	Newbie (to postgres) question ("Pedro B." <pedro.borracha@netcabo.pt>)
Responses	Re: Datetime Re: Datetime Re: Datetime
List	pgsql-sql

Tree view

Hello,

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.

Thanks,
\\pb

pgsql-sql by date:

From: Stephan Szabo
Date: 02 August 2004, 21:21:42
Subject: Re: Trigger and function not on speaking terms

From: Michael Glaesemann
Date: 03 August 2004, 10:57:32
Subject: Re: Datetime

Datetime - Mailing list pgsql-sql

Previous

Next