How to get the whole timestamp from a postgresql database

[Milas]

Hello,

Has anyone an idea on how I can get the timestamp from a PostgreSQL database with the fractional seconds information ? I'm using the database connectivity toolkit
Thanks

Salim

[Milas]

Ok, problem solved.

I had to query EXTRACT(MILLISECONDS FROM "Timestamp") and append the result to my timestamp (after removing the seconds in the returned string)

[Milas]

and there was even an easier solution




Why doing simple things when you can struggle for hours