Re: time format - Mailing list pgsql-hackers

From Tom Lane
Subject Re: time format
Date
Msg-id 21057.1073237581@sss.pgh.pa.us
Whole thread Raw
In response to Re: time format  (Martin Marques <martin@bugs.unl.edu.ar>)
Responses Re: time format  (ivan <iv@psycho.pl>)
Re: time format  (Martin Marques <martin@bugs.unl.edu.ar>)
List pgsql-hackers
Martin Marques <martin@bugs.unl.edu.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


pgsql-hackers by date:

Previous
From: "Andrew Dunstan"
Date:
Subject: Re: PL/Java issues
Next
From: Peter Eisentraut
Date:
Subject: Re: (Mis?)Behavior of \copy with -f and \i