Share via

ADF: Loading current Timestamp with Microsecond into PostgreSql db

MOHAMMED Tajmul 1 Reputation point
2022-05-15T13:20:23.703+00:00

Hi Team,
Could anyone suggest how to load current timstamp from azure data factory to Postgresql Database timestamp column with microsecnd.

I am trying with following but no luck.
ToTimestamp(ToString(currentTimestamp(), 'dd-MM-yyyy HH:mm:ss.ffffff'))
toString(currentTimestamp(), 'dd-MM-yyyy HH:mm:ss.SSSSSS')-- data showing with 3 digt.
//15-05-2022 13:14:42.000247
i am looking for 15-05-2022 13:14:42.342247

BR

Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
11,624 questions
Azure Database for PostgreSQL
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Subashri Vasudevan 11,226 Reputation points
    2022-05-15T16:34:06.45+00:00

    Hi @MOHAMMED Tajmul

    Thanks for posting your question on Microsoft Q&A.

    Please check the similar problem and suggested workaround here

    and here too

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.