Issue with javakdb Timestamp Handling in Non-UTC Timezones

[acosta-jef]

Hi javakdb team,

I’ve encountered an issue with the javakdb c.java class, where it only accepts Java Instant objects for kdb timestamp (type p) columns. Since Java Instant inherently represents timestamps in UTC, this creates a challenge when working with non-UTC timezones.

Specifically, I want to convert a timestamp to EST before sending it to kdb. It would be helpful if the library could support kdb timestamps in other timezones directly. Please let me know if there is a workaround for this issue, any help here would be much appreciated!

Thank you,
Andrew