Subject: ISO time zone format
From: Sabin Coanda
Date: 9/5/2007 4:09:15 PM
>
> If your DateStyle is set to ISO that's the default format. You don't need
> to use to_char()
>
> Or am I missing your point?
>
Hi Richard,
I'd just like to format it independent of my DateStyle. Some timestamp parts
may be formatted this way.
For instance I can format ISO date with to_char( dt, 'YYYY-MM-DD'), and ISO
time with to_char( dt, 'HH24:MI:SS') as well. I'd just like to find the
format pattern for the ISO time zone (numeric).
Regards,
Sabin
Subject: ISO time zone format
From: Sabin Coanda
Date: 9/5/2007 5:54:24 PM
>
> For the moment, you'll have to use extract() to pick out the bit(s) you
> need:
> to_char(extract(timezone_hour from current_timestamp), 'S00');
>
It's perfect for me, thanks a lot.
Sabin
|