Re: now() with microsecond granulity needed

From: Radoslaw Stachowiak <radek(at)alter(dot)pl>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: now() with microsecond granulity needed
Date: 2001-02-22 09:12:53
Message-ID: 20010222101253.F1718@blue.alter.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

*** Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> [Wednesday, 21.February.2001, 16:55 -0500]:
> Hmm, exactly what I was thinking of, except that it returns a text
> rather than a timestamp (a strange choice...).

But it's implicit casted to timestamp type so i think is good choice to
use in DEFAULT clause at this moment. Correct me if I'm wrong.

> It seems a little
> buggy as well because the formatting of the microseconds part is
> wrong --- will fix that, and document it.

In 7.1 version?

--
radoslaw.stachowiak.........................................http://alter.pl/

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Christopher Sawtell 2001-02-22 09:12:56 Re: logging a psql script
Previous Message hubert depesz lubaczewski 2001-02-22 07:20:45 creating tables with different character set?