world meaningful date time input

From: Dennis Gearon <gearond(at)sbcglobal(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: world meaningful date time input
Date: 2010-06-17 02:25:52
Message-ID: 528788.30236.qm@web82103.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


I've got an application brewing that gathers the following data:
location (lat/lon)
time (no time zone)
date. (no time zone)

The eventual goal is to be able to search chronologically using timestamps for the data anywhere in the world, from any location, using local time as a reference for any future date and time.

From the (lat/lon) it's possible to get:
named time zone
standard time zone offset (non dst)
by some special web services, get dates and amounts of
day light savings time

From there, it could possible to combine all the datums and create a timestamp with timezone (i.e. it's stored in absolute time (in seconds) relative to GMT)

Any easier way to do this?

Dennis Gearon

Signature Warning
----------------
EARTH has a Right To Life,
otherwise we all die.

Read 'Hot, Flat, and Crowded'
Laugh at http://www.yert.com/film.php

Responses

Browse pgsql-general by date

  From Date Subject
Next Message zhong ming wu 2010-06-17 02:42:02 oid data types mapping in libpq functions
Previous Message Merlin Moncure 2010-06-17 01:35:17 Re: postgres crash SOS