world meaningful date time input - Mailing list pgsql-general

From Dennis Gearon
Subject world meaningful date time input
Date
Msg-id 528788.30236.qm@web82103.mail.mud.yahoo.com
Whole thread Raw
Responses Re: world meaningful date time input  (Scott Marlowe <scott.marlowe@gmail.com>)
List 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
absolutetime (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

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: postgres crash SOS
Next
From: zhong ming wu
Date:
Subject: oid data types mapping in libpq functions