Re: timestamp no fractional seconds - Mailing list pgsql-general

From Tom Lane
Subject Re: timestamp no fractional seconds
Date
Msg-id 14567.1243961164@sss.pgh.pa.us
Whole thread Raw
In response to Re: timestamp no fractional seconds  (Brandon Metcalf <brandon@geronimoalloys.com>)
Responses Re: timestamp no fractional seconds
List pgsql-general
Brandon Metcalf <brandon@geronimoalloys.com> writes:
> I suppose my question really boils down to how do I cast the timestamp
> with no fractional seconds part?  For example, if I have a table where
> I haven't put a limit on the fractional seconds part, how would I
> select the timestamp without fractional seconds?

Cast to timestamp(0) ... which is something entirely different
from timestamp[0].

            regards, tom lane

pgsql-general by date:

Previous
From: Brandon Metcalf
Date:
Subject: Re: timestamp no fractional seconds
Next
From: "Edmundo Robles L."
Date:
Subject: Forcing the use of one index instead other.