Re: time format

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar>
Cc: ivan <iv(at)psycho(dot)pl>, 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 17:33:01
Message-ID: 21057.1073237581@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2004-01-04 18:07:11 Re: (Mis?)Behavior of \copy with -f and \i
Previous Message Andrew Dunstan 2004-01-04 17:28:57 Re: PL/Java issues