 <p>You need to convert the .NET ticks to UNIX Epoch and then to a postgreSQL timestamp.</p> <pre><code>to_timestamp((("date" - 621355968000000000) / 10000000)) </code></pre> <p>This code with work with version 9 and above</p>