On 01/03/2016 11:40 AM, Greg Jaskiewicz wrote:
Hi,
Is it easily possible to supply and receive tsrange types in epoch values, or
is it really all down always to string parsing?
AFAIK, not without resorting to a using some mishmash of EXTRACT,
to_date() and casting.
As a general rule, I pass time in the app in epoch-float values, which is then
converted by the presenter/controller layer to the right format used by views,
whether that’s a html app or some other type of an app. After all, I don’t
always need the date in the YYYY-MM-DD format, and I want to be independent
from the server configuration. Any wisdom on that front please ?
The way I do it, is I have a helper function that normalizes date/times
to one of two basic formats, mdy for users and iso for the internal Web
part(namely JavaScript). This is using Django and hence Python, where I
use the dateutil package(dateutil.readthedocs.org/en/latest/). It takes
care of all the ugliness of parsing date/time strings. I went this route
because dates and times can appear from a variety sources that are not
the database and which I have no control over.
--
Adrian Klaver
adrian.kla...@aklaver.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
