extract and time zones

Поиск
Список
Период
Сортировка
От Oscar Estevez Lopez
Тема extract and time zones
Дата
Msg-id 20030801133959.2f1d1283.oestevez@prisacom.com
обсуждение исходный текст
Ответы Re: extract and time zones  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: extract and time zones  (Dennis Gearon <gearond@cvc.net>)
Список pgsql-general
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?





--

________________________________________________________
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
CONFIDENTIALand/or LEGALLY PRIVILEGED  information and may not necessarily represent the opinion of this company. If
youreceive 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.   
============================================================================

В списке pgsql-general по дате отправления:

Предыдущее
От: "Tambet Matiisen"
Дата:
Сообщение: COPY and domains
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Error from Sub-Select, Simple Example.