From: | ivan <iv(at)psycho(dot)pl> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar>, Kurt Roeckx <Q(at)ping(dot)be>, Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: time format |
Date: | 2004-01-04 21:22:52 |
Message-ID: | Pine.LNX.4.56.0401042220480.13578@rex.anfa.pl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
i know, but i talking about default time output, it would be for
time, date and date with time, not formating all the time.
On Sun, 4 Jan 2004, Tom Lane wrote:
> Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar> writes:
> > Look deeper into what Christopher said and use casting to get the right
> > output:
> > prueba=> select now()::timestamp(0);
>
> There's also "current_timestamp(0)", which is a more standards-compliant
> way of doing the same thing.
>
> regards, tom lane
>
From | Date | Subject | |
---|---|---|---|
Next Message | Paul Ganainm | 2004-01-04 21:46:58 | Re: Is my MySQL Gaining ? |
Previous Message | A E | 2004-01-04 21:09:02 | Anything akin to an Evaluate Statement in Postgresql? |