On 2011-03-25 scrawf...@pinpointresearch.com (Steve Crawford) wrote:
> On 03/25/2011 10:05 AM, Marco wrote:
> > I have a column »timestamp with time zone«. I want to extract the
> > date/time in a different format including the time zone offset in a query
> > but without seconds. If I do
> >
> >
On Friday, March 25, 2011 10:05:59 am Marco wrote:
> I have a column »timestamp with time zone«. I want to extract the date/time
> in a different format including the time zone offset in a query but
> without seconds. If I do
>
> select to_char(datetime, '-MM-DD HH24:MI') from table;
>
> th
On 03/25/2011 10:05 AM, Marco wrote:
I have a column »timestamp with time zone«. I want to extract the date/time in
a different format including the time zone offset in a query but without
seconds. If I do
select to_char(datetime, '-MM-DD HH24:MI') from table;
then the time zone offset i
I have a column »timestamp with time zone«. I want to extract the date/time in
a different format including the time zone offset in a query but without
seconds. If I do
select to_char(datetime, '-MM-DD HH24:MI') from table;
then the time zone offset is missing in the output: 2011-03-25 18:0
