Right now, when we convert timestamp to datetime or datetime to timestamp, the library uses floating points to do the conversion. This introduces losses during the conversion as the datetime and timestamp datatypes do not support the same precision(nanoseconds).

For instance if we have a timestamp such as:
2024-04-16 08:43:09.420317+00:00
with the current implementation the nanoseconds in the resulting Timestamp object has 420316934 while it should be 420317000 instead.

or in this timestamp:
2024-04-16 08:43:09.400000+00:00
it has 400000095 nanoseconds instead of 400000000.