| From: | Allan Engelhardt <allane(at)cybaea(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | BUG in EXTRACT(MICROSECONDS...)? |
| Date: | 2001-08-10 22:32:38 |
| Message-ID: | 3B746106.294ED058@cybaea.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
Shouldn't EXTRACT treat TIME and TIMESTAMP the same when you are extracting time elements?
--- Allan.
test=# SELECT EXTRACT(MICROSECONDS FROM TIMESTAMP '2001-01-01 17:12:28.5');
date_part
-----------
500000
(1 row)
test=# SELECT EXTRACT(MICROSECONDS FROM TIME '17:12:28.5');
date_part
-----------
28500000
(1 row)
===
Name : postgresql Relocations: (not relocateable)
Version : 7.1.2 Vendor: (none)
Release : 4PGDG Build Date: Wed Jun 13 22:18:46 2001Install date: Fri Jun 29 20:43:51 2001 Build Host: lowen.wgcr.org
Group : Applications/Databases Source RPM: postgresql-7.1.2-4PGDG.src.rpm
Size : 4426307 License: BSD
URL : http://www.postgresql.org/
Summary : PostgreSQL client programs and libraries.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Allan Engelhardt | 2001-08-10 22:52:10 | How to change default time display format (and buglet?)? |
| Previous Message | Carl Karsten | 2001-08-10 19:12:24 | Re: the day before yesterday. |