problem insert time into column timestamp

From: "frank_lupo" <frank_lupo(at)email(dot)it>
To: "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: problem insert time into column timestamp
Date: 2002-07-31 16:47:36
Message-ID: H04HBC$Is0phMa3hoMjouSbvYxD4w7KlT5xkqBmWAUZxszbAItZdw@email.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Fabiàn R.Breschi 2002-07-31 17:03:24 MySQL or Postgres ?
Previous Message Marc G. Fournier 2002-07-31 14:21:22 Re: Have been accepted as a writer for "The Register"