Re: Datetime

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