Re: extract and time zones

From: Oscar Estevez Lopez <oestevez(at)prisacom(dot)com>
To: gearond(at)cvc(dot)net
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: extract and time zones
Date: 2003-08-11 15:10:25
Message-ID: 20030811171025.2bddb479.oestevez@prisacom.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-general

El Fri, 01 Aug 2003 08:19:25 -0700
Dennis Gearon <gearond(at)cvc(dot)net> escribio:

Cut'n paste :P

> Don't know the answer to your question, but how did you type all those commands in one second? :-)
>
> Oscar Estevez Lopez wrote:
>
> > Um, and what about this?
> >
> > $ uname -a
> > FreeBSD caneli 4.7-RELEASE FreeBSD 4.7-RELEASE #1: Fri May 9 02:30:11 CEST 2003 root(at)caneli:/usr/obj/usr/src/sys/CANELI i386
> >
> > $ psql --version
> > psql (PostgreSQL) 7.2.2
> > contains support for: readline, history, multibyte
> > Portions Copyright (c) 1996-2001, PostgreSQL Global Development Group
> > Portions Copyright (c) 1996, Regents of the University of California
> > Read the file COPYRIGHT or use the command \copyright to see the
> > usage and distribution terms.
> >
> > create table t1( d timestamp(0) without time zone );
> > CREATE
> >
> > insert into t1 values( current_timestamp );
> > INSERT 26251 1
> >
> >
> > select * from t1;
> > d
> > ---------------------
> > 2003-08-01 13:30:38
> > (1 row)
> >
> > select extract( epoch from d ) from t1;
> > date_part
> > ------------
> > 1059744638
> > (1 row)
> >
> > select extract( epoch from d::timestamp ) from t1;
> > date_part
> > ------------
> > 1059737438
> > (1 row)
> >
> > d : 1059744638
> > d::timestamp : 1059737438
> >
> > ??
> >
> > Does 'epoch from d' check time zone and 'epoch from d::timestamp' doesn't?
> >
> >
> >
> >
> >
>

--

________________________________________________________
One ping to rule them all, one ping to find them,
one ping to bring them all and in the darkness bind them.
(Lord of the windows)

============================================================================
This e-mail message and any attached files are intended SOLELY for the addressee/s identified herein. It may contain CONFIDENTIAL and/or LEGALLY PRIVILEGED information and may not necessarily represent the opinion of this company. If you receive this message in ERROR, please immediately notify the sender and DELETE it since you ARE NOT AUTHORIZED to use, disclose, distribute, print or copy all or part of the contained information. Thank you.
============================================================================

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Oscar Estevez Lopez 2003-08-11 15:11:30 Re: extract and time zones
Previous Message Tom Lane 2003-08-11 14:52:59 Re: Correct Unicode sorting depends on how initdb was run

Browse pgsql-general by date

  From Date Subject
Next Message Oscar Estevez Lopez 2003-08-11 15:11:30 Re: extract and time zones
Previous Message Tom Lane 2003-08-11 15:05:57 Re: How to prevent vacuum and reindex from deadlocking.