Simon Bæk Carstensen wrote:
> I guess I need a combination of the 2 queries above - one that asks for
> ONLY the year in a certain time zone (fx UTC or CET).
The easiest way is to do
SET TimeZone TO 'CET';
[from now on all timestamps will be returned CET-base]
SELECT ...
You can then
SET TimeZone TO DEFAULT;
or wait for the end of the connection.
--
Alessio F. Bragadini alessio(at)albourne(dot)com
APL Financial Services http://village.albourne.com
Nicosia, Cyprus phone: +357-2-755750
"It is more complicated than you think"
-- The Eighth Networking Truth from RFC 1925