Quick Links

Datetime

From:	"Pedro B(dot)" <pedro(dot)borracha(at)netcabo(dot)pt>
To:	pgsql-sql(at)postgresql(dot)org
Subject:	Datetime
Date:	2004-08-03 07:22:51
Message-ID:	410F3D4B.60405@netcabo.pt
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-sql

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

In response to

Newbie (to postgres) question at 2004-07-08 13:36:37 from Pedro B.

Responses

Re: Datetime at 2004-08-03 10:23:14 from Achilleus Mantzios
Re: Datetime at 2004-08-03 10:56:56 from Michael Glaesemann
Re: Datetime at 2004-08-03 10:58:26 from Devrim GUNDUZ

Browse pgsql-sql by date

	From	Date	Subject
Next Message	Achilleus Mantzios	2004-08-03 10:23:14	Re: Datetime
Previous Message	mike g	2004-08-03 03:31:41	Re: error in compiling the function -- need help !!!