Timestamp data type problems
От | Olivier PRENANT |
---|---|
Тема | Timestamp data type problems |
Дата | |
Msg-id | Pine.UW2.4.21.0005291422570.3837-100000@server.pyrenet.fr обсуждение исходный текст |
Ответы |
Re: Timestamp data type problems
|
Список | pgsql-hackers |
Please help! I'm having troubles with the timestamp type: here's a psql output : Script started on Mon May 29 13:32:08 2000 ~ 13:32:08: psql pyrenet Welcome to psql, the PostgreSQL interactive terminal. Type: \copyright for distribution terms \h for help with SQL commands \? for help on internal slash commands \g or terminate with semicolon to execute query \q to quit pyrenet=# select 'today'::date; ?column? ------------29-05-2000 (1 row) pyrenet=# select 'today'::timestamp ?column? -------------------------------------------Mon 29 May 00:00:00 2000 MET DST(ÎäÍ^A (1 row) script done on Mon May 29 13:44:30 2000 As you can see, there's no \0 after TZ. Checking to code led me to EncodeTimeSpan that does strcpy and strncpy and never puts a null character. Could this be a bug? That's breaking all my scripts because if I add a timespan value to it, then the backend complains about bad formated external timestamp. Please help! This is V7.0 on Unixware 7.0.1 compiled with cc. -- Olivier PRENANT Tel: +33-5-61-50-97-00 (Work) Quartier d'Harraud Turrou +33-5-61-50-97-01 (Fax) 31190 AUTERIVE +33-6-07-63-80-64 (GSM) FRANCE Email: ohp@pyrenet.fr ------------------------------------------------------------------------------ Make your life a dream, make your dream a reality. (St Exupery)
В списке pgsql-hackers по дате отправления: