Hello Deepanshu, I suggest you do the transformation in the query in the "QueryDatabaseTable".
Using a combination of string functions substring() and or date functions until you build the string you need on the MSSQL side. On Thu, Sep 5, 2024 at 4:01 AM Deepanshu Lodhi <[email protected]> wrote: > Hi all, > > I've created a simple data flow using "QueryDatabaseTable" and > "PutDatabaserRecord" which transfers the data from PostgreSQL DB to > MSSQLServer DB in which the datatype of datetime columns in source_db i.e., > PostgreSQL table is "timestamp without time zone", which is not compatible > with destination_db i.e., MSSQLServer. > > This logs an error, what would be the correct method to transform the > datatype of the datetime columns while serving data from PostgreSQL to > MSSQLServer. > > Can anyone give me a tip how to transform the datatype of the such columns? > > *Thankyou in advance* > Deepanshu > -- Dennis N Brown Mobile: +1 919-368-4334 Linkedin <https://linkedin.com/in/dennis-n-brown-nthedata> US PostgreSQL Association <https://postgresql.us/>
