Re: timestamp no fractional seconds

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