Ange Michel POZZO <[EMAIL PROTECTED]> writes:
> select datetime(abstime( floor (value) ));
> select datetime(abstime( int4 (value) ));
> select datetime(abstime( numeric_int4 (value) ));
> in all case :
> ERROR: pg_atoi: error in "952969611.00": can't parse ".00"
That was fixed in Janu
On Thu, 3 Aug 2000, Ange Michel POZZO wrote:
> Le jeu, 03 aoű 2000, Karel Zak a écrit :
> > > my question is how can i convert the numeric or the int4 value to
> > > a date value?
> >
> >
> > test=# select abstime(965293003);
> > abstime
> >
> > 2000-08-03 10
Le jeu, 03 aoû 2000, Karel Zak a écrit :
> > my question is how can i convert the numeric or the int4 value to
> > a date value?
>
>
> test=# select abstime(965293003);
> abstime
>
> 2000-08-03 10:56:43+02
> (1 row)
>
> Ka
> my question is how can i convert the numeric or the int4 value to
> a date value?
test=# select abstime(965293003);
abstime
2000-08-03 10:56:43+02
(1 row)
Karel
hi all
i have a table like this
id_message int4 not null default nextval ( ...
id_abonneint4
texte_message varchar() not null
date_message numeric not null
the default size of numeric is 30.6
another table :
id_message int4
id_abonneint4
text_message text
date
