pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Marcelo Bartsch <bartschm@psi.com>
To: Postgres SQL list <pgsql-sql@postgresql.org>
Subject: How to display a unixtimestamp from a timestamp record?
Date: Mon, 15 Jan 2001 12:56:38 -0300
Message-ID: <3A631DB6.7EA75DFB@psi.com> (raw)

Hello!
	again i was faced to a problem i was trying to do create view in wich i
had the next fields:

CREATE TABLE "tbacct" (
	"user_name" character varying(32),
	"nas_identifier" character varying(15),
	"nas_port" int4,
	"acct_session_id" character varying(15),
	"caller_id" character varying(16),
	"called_station_id" character varying(16),
	"framed_ip_address" character varying(15),
	"acct_disconnect_cause" character varying(40),
	"acct_session_time" int4,
	"acct_timestamp" timestamp,
	"realm" character varying(64)
);

and i need view in wich acct_timestamp is a int8

USERNAME
IP-ADDRESS
74
000B2E5B
NULL
6572
IP-ADDRESS
NULL
4
2000-11-13 14:19:45-03
REALM

and i want it to be displayed something like this:

USERNAME
IP-ADDRESS
74
000B2E5B
NULL
6572
IP-ADDRESS
NULL
4
974135985
REALM

i know it is possible using date_part
select date_part( 'epoch' , timestamp '2000-11-13 14:30:40');
gave the right answer . but when i executte

 select user_name, date_part( 'epoch' , timestamp 'acct_timestamp') from
tbacct limit 2;

it said ERROR:  Bad timestamp external representation 'acct_timestamp'
how should i represent date_part( 'epoch' , timestamp 'acct_timestamp')
to work?

Thanks in Advance

-- 
Marcelo Bartsch R.
bartschm@psi.com
PSINet Chile

/O /Ot Minimize execution speed (default)
Microsoft C/C++ Compiler Documentation,
'Enviroment and Tools', p531

Telefono         : +56-2-3979000
Numero de Fax    : +56-2-3979090
Numero de eFax   : (815) 366-3177



view thread (2+ messages)  latest in thread

Message-ID: <3A631DB6.7EA75DFB@psi.com>
Permalink:  ../3A631DB6.7EA75DFB@psi.com/
Also on:    postgresql.org/message-id/3A631DB6.7EA75DFB@psi.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-sql@postgresql.org
  Cc: bartschm@psi.com
  Subject: Re: How to display a unixtimestamp from a timestamp record?
  In-Reply-To: <3A631DB6.7EA75DFB@psi.com>
  References: <3A631DB6.7EA75DFB@psi.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox