Re: time format

From: ivan <iv(at)psycho(dot)pl>
To: Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: time format
Date: 2004-01-03 08:25:14
Message-ID: Pine.LNX.4.56.0401030919210.28459@rex.anfa.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


but what about default style ?
first time when i saw DateStyle i thought that i can use it like C/C++
function strftime. I would be not bad idea to have custom data style :)

On Fri, 2 Jan 2004, Christopher Kings-Lynne wrote:

> Create table with type TIMESTAMP(0)
>
> Chris
>
> ivan wrote:
>
> >
> > how can i change default time format because now i have for example
> > 2004-01-01 16:51:46.995927 but i want only 2004-01-01 16:51:46, with out
> > millisec. a tryed with Data-Style but there arent custom style :/
> >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> > http://archives.postgresql.org
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo(at)postgresql(dot)org
>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kurt Roeckx 2004-01-03 11:19:06 Re: time format
Previous Message Christopher Kings-Lynne 2004-01-03 06:49:23 Re: Postgres + Xapian (was Re: fulltext searching via a