Home > mailing lists

Thread: time precision.

time precision.

From

"Anagha Joshi"

Date:

30 July 2003, 04:54:39

Hi All,

I�m using PG-7.2.4 on Solaries.

When I do:

template1=# select time(6576);

ERROR:� TIME(6576) precision must be between 0 and 13

Where am I wrong?

Pls. help

Thanks,

Anagha

Re: time precision.

From

Christoph Haller

Date:

30 July 2003, 06:12:53

> I'm using PG-7.2.4 on Solaries.
> When I do:
>
> template1# select time(6576);
> ERROR:  TIME(6576) precision must be between 0 and 13
>
> Where am I wrong?

What's the purpose of this function? And where did you find it in the
docs?
I didn't see it before.

Regards, Christoph

Re: time precision.

From

Stephan Szabo

Date:

30 July 2003, 06:46:27

On Wed, 30 Jul 2003, Anagha Joshi wrote:

> Hi All,
> I'm using PG-7.2.4 on Solaries.
> When I do:
>
> template1=# select time(6576);
> ERROR:  TIME(6576) precision must be between 0 and 13
>
> Where am I wrong?

IIRC time(n) refers to the type time with a precision of n
and n is limited as stated by the error. What are you trying
to do?