Re: [GENERAL] Time Input with format HH.MM.SS

2007-02-01 Thread DANTE Alexandra
Thank you Andreas, I had thought about this solution but in my case, it is not really possible to do that... I am converting an Oracle database to PostgreSQL 8.2.0 via ora2pg which allows me to extract the tables, data, ... The timestamp extracted from Oracle have the format "DD-MON-YY HH.MI.SSX

Re: [GENERAL] Time Input with format HH.MM.SS

2007-02-01 Thread A. Kretschmer
am Thu, dem 01.02.2007, um 16:13:28 +0100 mailte A. Kretschmer folgendes: > am Thu, dem 01.02.2007, um 15:58:08 +0100 mailte DANTE Alexandra folgendes: > > Hello List, > > > > Is it possible to import in a TIMESTAMP(6) field a timestamp in which > > the format of hour is HH.MM.SS (and not HH:MM

Re: [GENERAL] Time Input with format HH.MM.SS

2007-02-01 Thread A. Kretschmer
am Thu, dem 01.02.2007, um 15:58:08 +0100 mailte DANTE Alexandra folgendes: > Hello List, > > Is it possible to import in a TIMESTAMP(6) field a timestamp in which > the format of hour is HH.MM.SS (and not HH:MM:SS) ? > In the documentation, at > http://www.postgresql.org/docs/8.2/interactive/d

[GENERAL] Time Input with format HH.MM.SS

2007-02-01 Thread DANTE Alexandra
Hello List, Is it possible to import in a TIMESTAMP(6) field a timestamp in which the format of hour is HH.MM.SS (and not HH:MM:SS) ? In the documentation, at http://www.postgresql.org/docs/8.2/interactive/datatype-datetime.html#DATATYPE-TIMEZONES, I didn't find this format. So can I think tha