| 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: | Whole Thread | Raw Message | 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" |