pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Allan Engelhardt <allane@cybaea.com>
To: pgsql-sql@postgresql.org
Subject: BUG in EXTRACT(MICROSECONDS...)?
Date: Fri, 10 Aug 2001 23:32:38 +0100
Message-ID: <3B746106.294ED058@cybaea.com> (raw)

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.






Message-ID: <3B746106.294ED058@cybaea.com>
Permalink:  ../3B746106.294ED058@cybaea.com/
Also on:    postgresql.org/message-id/3B746106.294ED058@cybaea.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 using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: allane@cybaea.com
  Subject: Re: BUG in EXTRACT(MICROSECONDS...)?
  In-Reply-To: <3B746106.294ED058@cybaea.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