question

MOHAMMEDTajmul-3451 avatar image
0 Votes"
MOHAMMEDTajmul-3451 asked ShaikMaheer-MSFT commented

ADF: Loading current Timestamp with Microsecond into PostgreSql db

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-factoryazure-database-postgresql
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

SubashriVasudevan-1752 avatar image
0 Votes"
SubashriVasudevan-1752 answered ShaikMaheer-MSFT commented

Hi @MOHAMMEDTajmul-3451

Thanks for posting your question on Microsoft Q&A.

Please check the similar problem and suggested workaround here


and here too


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @MOHAMMEDTajmul-3451,

Just checking in to see if the above answer helped. If this answers your query, do click 130616-image.png and upvote 130671-image.png for the same. And, if you have any further query do let us know.

0 Votes 0 ·