DATEADD should support fractional value for MILLISECOND
-------------------------------------------------------
Key: CORE-4457
URL: http://tracker.firebirdsql.org/browse/CORE-4457
Project: Firebird Core
Issue Type: Improvement
Components: Engine
Affects Versions: 2.5.2 Update 1
Reporter: Mark Rotteveel
Timestamps in Firebird have a 100 microsecond resolution, however the built-in
DATEADD takes only integer values this makes it impossible to modify the 100
microsecond value of a TIMESTAMP.
For example:
SELECT CAST(DATEADD(-1 * EXTRACT(MILLISECOND FROM ts) MILLISECOND TO ts) AS
VARCHAR(30)), EXTRACT(MILLISECOND FROM ts)
FROM (
SELECT TIMESTAMP'2014-06-09 13:50:17.4971' as ts
FROM RDB$DATABASE
) a
has output:
2014-06-09 13:50:17.0001 497.1
I would expect (or prefer) output:
2014-06-09 13:50:17.0000
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
------------------------------------------------------------------------------
HPCC Systems Open Source Big Data Platform from LexisNexis Risk Solutions
Find What Matters Most in Your Big Data with HPCC Systems
Open Source. Fast. Scalable. Simple. Ideal for Dirty Data.
Leverages Graph Analysis for Fast Processing & Easy Data Exploration
http://www.hpccsystems.com
Firebird-Devel mailing list, web interface at
https://lists.sourceforge.net/lists/listinfo/firebird-devel
