On Sun, Jun 26, 2005 at 12:24:53AM -0300, Marc G. Fournier wrote:
>
> Does anyone have a 'table of timezones' that could be used to "localize"
> as part of a query?
>
> For instance, something like:
>
> SELECT date
> FROM table
> WHERE ( time || ' ' || ( SELECT timezone
>
Does anyone have a 'table of timezones' that could be used to "localize"
as part of a query?
For instance, something like:
SELECT date
FROM table
WHERE ( time || ' ' || ( SELECT timezone
FROM zones
WHERE id = table.timezone )) = '2004-
