Skip site navigation (1) Skip section navigation (2)

Decimal digits in timeofday()

From: Nicola Larosa <nico(at)tekNico(dot)net>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Decimal digits in timeofday()
Date: 2001-10-24 13:38:57
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
There's a cute little bug somewhere.


   SELECT timeofday();

returns six decimal digits,

   SELECT date_part('epoch', timeofday()::timestamp);

only returns five, on a Linux Slackware 8.0 x86 machine with PostgreSQL 7.1.1 .

Please do not make me dive into C code again, already fixed a similar bug in 
Zope , but in Python (it shaved off two digits instead of one, but anyway...)

Another thing, does anyone know where I could see the docs for the new 
to_timestamp microsecond-aware function in 7.2?

Lastly, thanks for the fine software. Just donated 50$ to PostgreSQL Inc., 
it feels good. :^)

"Mozilla will be around long after nobody can remember
just quite what Internet Explorer actually used to be."
   AirLace on Slashdot

Nicola Larosa - nico(at)tekNico(dot)net


pgsql-bugs by date

Next:From: ArguileDate: 2001-10-24 15:38:38
Subject: New default ignored by pre-exising insert rulesets.
Previous:From: Bill StudenmundDate: 2001-10-24 13:21:05
Subject: Re: Enabling --debug causes regression test failure.

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group