pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: Pedro B. <pedro.borracha@netcabo.pt>
To: pgsql-sql@postgresql.org
Subject: Datetime
Date: Tue, 03 Aug 2004 08:22:51 +0100
Message-ID: <410F3D4B.60405@netcabo.pt> (raw)
In-Reply-To: <40ED4DE5.7020807@netcabo.pt>
References: <77ED2BF75D59D1439F90412CC5B109740E8A2E38@ie10-sahara.hiso.honeywell.com>
	<40EBD891.3050205@archonet.com>
	<005801c464dd$72b5bec0$0403a8c0@fejleszt4>
	<40ED4DE5.7020807@netcabo.pt>

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

view thread (11+ messages)  latest in thread

Message-ID: <410F3D4B.60405@netcabo.pt>
Permalink:  ../410F3D4B.60405@netcabo.pt/
Also on:    postgresql.org/message-id/410F3D4B.60405@netcabo.pt

copy link · copy postgr.es

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: pedro.borracha@netcabo.pt
  Subject: Re: Datetime
  In-Reply-To: <410F3D4B.60405@netcabo.pt>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox