Re: extract and time zones

On Fri, 2003-08-01 at 10:19, Dennis Gearon wrote:
> Don't know the answer to your question, but how did you type all those commands in one second? :-)

From a script?

$ psql -a -f bar.sql template1
drop table bar;
DROP TABLE
create table bar (f1 timestamp);
CREATE TABLE
insert into bar values (current_timestamp);
INSERT 17010 1
insert into bar values (current_timestamp);
INSERT 17011 1
select extract(epoch from f1) from bar;
    date_part
------------------
 1059752510.67238
 1059752510.69783
(2 rows)


> 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@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?
> >
> >
> >
> >
> >
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
--
+-----------------------------------------------------------------+
| Ron Johnson, Jr.        Home: ron.l.johnson@cox.net             |
| Jefferson, LA  USA                                              |
|                                                                 |
| "I'm not a vegetarian because I love animals, I'm a vegetarian  |
|  because I hate vegetables!"                                    |
|    unknown                                                      |
+-----------------------------------------------------------------+