SAP / node-hdb

SAP HANA Database Client for Node
Apache License 2.0
317 stars 97 forks source link

Support timestamp seconds precisions with more than 3 fractional digits #210

Open schwma opened 1 year ago

schwma commented 1 year ago

Hi,

we want to use timestamps with seconds precisions of more than 3 fractional digits, such as 2022-11-05T12:35:44.1234567Z. SAP HANA supports up to 7 digits which are correctly written and read by @sap/hana-client. However, unfortunately it seems as though in node-hdb the fractional digits are always rounded to 3 decimal places here and probably also here.

Could you please add support for seconds precisions of more than 3 fractional digits?

Thanks!

schwma commented 1 year ago

Upon further investigation it appears as though support for the LONGDATE input and output field format, which along with SECONDDATE is the endorsed format for transferring TIMESTAMPs, needs to be implemented in order to support timestamps with seconds precisions of more than 3 fractional digits.