Rich Shepard wrote:
On Fri, 18 Jan 2013, Adrian Klaver wrote:

test=> SELECT ('2012-10-29 '||'10:19')::timestamp;
2012-10-29 10:19:00
Thanks, Adrian. I suspected it was simple but I could not find a reference
to the syntax.
Of course, since you appear to want to deal with moments in time,
timestamptz is more appropriate than just timestamp. If the values
are in UTC, then you will want to append that to the string. You
might use something like:

test=# SELECT ('2012-10-29 '||'10:19'||' +00')::timestamptz;
  2012-10-29 05:19:00-05
(1 row)

If they're not already in UTC and your locale has a seasonal offset
like Daylight Saving Time, you might want to be careful with how
you handle data around the autumnal shift, or you could have things
which finish before they started.


Search Discussions

Discussion Posts


Follow ups

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 8 of 9 | next ›
Discussion Overview
grouppgsql-general @
postedJan 18, '13 at 11:31p
activeJan 19, '13 at 5:51p



site design / logo © 2021 Grokbase