world meaningful date time input

Поиск
Список
Период
Сортировка
От Dennis Gearon
Тема world meaningful date time input
Дата
Msg-id 528788.30236.qm@web82103.mail.mud.yahoo.com
обсуждение исходный текст
Ответы Re: world meaningful date time input  (Scott Marlowe <scott.marlowe@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: postgres crash SOS
Следующее
От: zhong ming wu
Дата:
Сообщение: oid data types mapping in libpq functions