How to get milliseconds from timestamp field if my connection library does not support it?
You can use EXTRACT like this:
SELECT EXTRACT(SECOND FROM timestamp_column) FROM table_name;
It will return the number of seconds and milliseconds with 4 decimal digits (the result is decimal(9,4)). Alternatively, you can CAST the timestamp to CHAR or VARCHAR, and get the result as string. Example:
SELECT CAST(timestamp_column AS VARCHAR(24)) FROM table_name;