| From: | "Lane Van Ingen" <lvaningen(at)esncc(dot)com> |
|---|---|
| To: | <pgsql-sql(at)postgresql(dot)org> |
| Subject: | What Am I Doing Wrong? |
| Date: | 2005-10-18 19:38:54 |
| Message-ID: | EKEMKEFLOMKDDLIALABIIEPMCDAA.lvaningen@esncc.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
I have been trying to subtract two timestamps from each other to determine
the difference between the two timestamps (current time and a past timestamp
called 'updated_time') IN SECONDS, but no luck.
The trouble I am having is getting the first timestamp, representing the
current time, to translate to seconds; have tried different commands (now(),
localtimestamp, current_timestamp, etc)
What am I doing wrong? Sample statement and error message is below:
------------------------------------------
select EXTRACT(EPOCH from TIMESTAMP current_timestamp) - EXTRACT(EPOCH from
TIMESTAMP updated_time) ::integer
ERROR: syntax error at or near "current_timestamp" at character 37
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lane Van Ingen | 2005-10-18 21:20:25 | Re: What Am I Doing Wrong? |
| Previous Message | Mario Splivalo | 2005-10-18 14:49:59 | Re: Consulta! |