Postgres Pro
Downloads
Home   >   mailing lists

Return value error of‘to_timestamp’ - Mailing list pgsql-bugs

From 甄明洋
Subject Return value error of‘to_timestamp’
Date
Msg-id 379c479a.f0c.15653e44bba.Coremail.zhenmingyang@yeah.net
Whole thread Raw
Responses Re: [BUGS] Return value error of‘to_timestamp’
List pgsql-bugs
Tree view
When the fractional seconds more than 6, the return value of to_timestamp without truncation.
Postgres think the total value of the.123456789 as a fractional second part and convert to microsecond stored in database.
 example:
postgres=# select to_timestamp('1990-1-1 11:11:11.123456789', 'YYYY-MM-DD HH24:MI:SS.US');
         to_timestamp
-------------------------------
 1990-01-01 11:13:14.456789+08
(1 row)
postgres=#



 

pgsql-bugs by date:

Previous
From: digoal@126.com
Date:
Subject: BUG #14277: when define USE_NAMED_POSIX_SEMAPHORES , make error
Next
From: paco@hernandezgomez.com
Date:
Subject: BUG #14278: Problem searching spanish words with accent mark outside the stem