| From: | hubert depesz lubaczewski <depesz(at)depesz(dot)com> |
|---|---|
| To: | Brandon Metcalf <brandon(at)geronimoalloys(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: timestamp no fractional seconds |
| Date: | 2009-06-02 16:40:03 |
| Message-ID: | 20090602164002.GA29262@depesz.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Jun 02, 2009 at 11:26:05AM -0500, Brandon Metcalf wrote:
> Am I creating the table correctly? If so, how do I insert or update
> rows?
timestamp[] is array of timestamps.
there is no way to make timestamps "without subsecond data".
you can add trigger to remove unneeded parts of the data, or (much
better) strip it while selecting data - for example, using to_char()
function.
Best regards,
depesz
--
Linkedin: http://www.linkedin.com/in/depesz / blog: http://www.depesz.com/
jid/gtalk: depesz(at)depesz(dot)com / aim:depeszhdl / skype:depesz_hdl / gg:6749007
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brandon Metcalf | 2009-06-02 16:40:08 | Re: timestamp no fractional seconds |
| Previous Message | Brandon Metcalf | 2009-06-02 16:26:05 | timestamp no fractional seconds |