Stephan Szabo <[EMAIL PROTECTED]> writes:
> On Thu, 13 Feb 2003, Jeff Boes wrote:
>> Is there a straightforward way to change the display of a time to another
>> timezone? For example, my server's environment is EST (-0500); I want to
>> convert timestamps for display in PST (-0800).
> I think yo
Is there a straightforward way to change the display of a time to another
timezone? For example, my server's environment is EST (-0500); I want to
convert timestamps for display in PST (-0800). What I've been doing is to use a
Pl/Pgsql function to subtract the current timezone-offset and add in t
Hi Cedar,
Does this help?
select CURRENT_TIMESTAMP, CURRENT_TIMESTAMP + '90 days';
timestamp|?column?
+
2001-04-24 12:57:56+01 | 2001-07-23 12:57:56+01
>
> I also have a question.. How, for example, would I add 90
Umm.. define 'it'. (Isn't current_timestamp or now() already a
timestamp?)
select CURRENT_TIMESTAMP, CURRENT_TIMESTAMP-2*3600;
timestamp| ?column?
+
2001-04-24 13:06:11+03 | 1981-08-07
I also have a question.. How, for example, would I add
Convert it to timestamp and minus TIMEZONE * 3600...
On Wed, 11 Apr 2001, Roberto Mello wrote:
> Hi,
>
> How can I do timezone conversions in PG? I looked on the docs and
> couldn't find how. I want to find the current time in another timezone.
>
> Thanks,
>
> -Roberto
Hi,
How can I do timezone conversions in PG? I looked on the docs and
couldn't find how. I want to find the current time in another timezone.
Thanks,
-Roberto
P.S: This type of function would be excellent on the cookbook
(www.brasileiro.net).
--
+| http://f
