dynamobi/dynamobi — Issue #531: [FRG-341] Cast CHAR / VARCHAR string to TIMESTAMP rounds to nearest second
Author: dynamobi-build
Created: 2011-12-30 03:33:37+00:00
State: open
Labels: FRG, Statement Processing

[reporter="nigel.thomas", created="Wed, 3 Sep 2008 10:14:08 -0500 (GMT-05:00)"]
0: jdbc:farrago:rmi://localhost> values( cast('2008-08-23 12:34:56.789' AS TIMESTAMP) );

+------------------------+

| EXPR$0 |

+------------------------+

| 2008-08-23 12:34:57.0 |

+------------------------+

1 row selected (1.609 seconds)

See how the 56.789 seconds gets rounded to 57.0? It should surely retain as much precision as possible

Note this _may_ be related to FRG-282.