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
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" |