Functions receiving argument of type timezone.
The problem I am having is that a function with the definition
loctolisttime(timestamp, interval, integer)
When I attempt to call that function with
timestamp 'now' AT TIME ZONE interval '0 hours' (I need to pass the current
time at gmt) I get the error.
ERROR: Function loctolisttime(timestamp with time zone, interval, integer)
does not exist Unable to identify a function that satisfies the given
argument types You may need to add explicit typecasts
when I pass it an argument from a field of a table which is of type timestamp,
it works fine...
any idea how I can get a UTC timestamp into that function?
Josh.
A list of possible solutions that I cna't figure out how to do..
a) Is there a way to declare a function accepting an argument of type
"timestamp with time zone"?
b) Is there a special function like utc_now, or CURRENT_UTC_TIMESTAMP or
something I could pass to the function?
Josh.
On Thu, 13 Mar 2003, Joshua Moore-Oliva wrote:
A list of possible solutions that I cna't figure out how to do..
a) Is there a way to declare a function accepting an argument of type
"timestamp with time zone"?
You should just be able to declare the function saying the argument is
timestamp with time zone afaics. I tried in in 7.3.1 and 7.4 devel.