Timestamp and interval precision
От | Vilson farias |
---|---|
Тема | Timestamp and interval precision |
Дата | |
Msg-id | 011201c39a32$d7f1b490$98a0a8c0@dgtac обсуждение исходный текст |
Ответы |
Re: Timestamp and interval precision
|
Список | pgsql-general |
Greetings, I was doing some tests with timestamps and intervals and I've discovered, for my surprise, that I can't set precision for resulting fields of type interval when I'm executing a query. Please follow my tests : bxs=# select CAST('10:32:14.553243' AS interval); interval ----------------- 10:32:14.553243 (1 row) bxs=# select CAST('10:32:14.553243' AS interval(0)); interval ----------------- 10:32:14.553243 (1 row) But I can set precision when it's a timestamp : bxs=# SELECT CAST('2003-10-09 23:45:34.543543' AS timestamp); timestamp ---------------------------- 2003-10-09 23:45:34.543543 (1 row) bxs=# SELECT CAST('2003-10-09 23:45:34.543543' AS timestamp(0)); timestamp --------------------- 2003-10-09 23:45:35 (1 row) Is it a known limitation? Best regards, ---------------------------------------------------------------------------- ---- José Vilson de Mello de Farias Software Engineer Dígitro Tecnologia Ltda - www.digitro.com.br APC - Customer Oriented Applications E-mail: vilson.farias@digitro.com.br Tel.: +55 48 281 7158 ICQ 11866179
В списке pgsql-general по дате отправления: