When working with Ingres, it is possible to create a field "date"
and insert into this a time value e.g. '10:12:12'
the current date is assigned automatically by Ingres
e.g. '31/07/2002 10:12:12'
When working with Postgres, I receive an error when trying to insert a
time value into a timestamp field
gedis30=# create table pippo (aa timestamp)\g
gedis30=# insert into pippo (aa) values('10:12:12')\g
ERROR: Bad timestamp external representation '10:12:12'
How can I solve this problem ?
Bye !!
Frank Lupo (Wolf) !!
--
Prendi GRATIS l'email universale che... risparmia: http://www.email.it/f
Sponsor:
Il nostro catalogo completo a casa tua, gratis! Vieni da Peraga, tanti prodotti introvabili per te.
Clicca qui: http://adv2.email.it/cgi-bin/foclick.cgi?mid=450&d=31-7