Re: extract and time zones
От | Ron Johnson |
---|---|
Тема | Re: extract and time zones |
Дата | |
Msg-id | 1059752577.7505.600.camel@haggis обсуждение исходный текст |
Ответ на | Re: extract and time zones (Dennis Gearon <gearond@cvc.net>) |
Список | pgsql-general |
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 | +-----------------------------------------------------------------+
В списке pgsql-general по дате отправления: