>
> 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
---(end of broadcast)---
TIP 1: if posting/reading t
Sabin Coanda wrote:
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, '-MM-DD'), and ISO
time with to_char( dt, 'HH24:MI:SS') as well. I'd just like to find the
format pattern for
>
> 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
Sabin Coanda wrote:
Hi there,
I'd like to format a time stamp with time zone as ISO pattern (e.g.
1999-01-08 04:05:06 -8:00)
I found the patterns for all the timestamp parts, from "Data Type Formatting
Functions" Postgresql documentation, excepting the numeric ISO time zone.
Please suggest
Στις Τετάρτη 05 Σεπτέμβριος 2007 10:30, ο/η Sabin Coanda έγραψε:
> Hi there,
>
> I'd like to format a time stamp with time zone as ISO pattern (e.g.
> 1999-01-08 04:05:06 -8:00)
>
> I found the patterns for all the timestamp parts, from "Data Type
> Formatting Functions" Postgresql documentation, e
Hi there,
I'd like to format a time stamp with time zone as ISO pattern (e.g.
1999-01-08 04:05:06 -8:00)
I found the patterns for all the timestamp parts, from "Data Type Formatting
Functions" Postgresql documentation, excepting the numeric ISO time zone.
Please suggest the appropiate pattern
