Forum Discussion

jaybodra's avatar
jaybodra
New Contributor III
9 years ago

How to use 3rd party python libraries in python Script

Please can some shed some light on using a third party library (boto3, requests) in a python script Thank you in advance!
kristinajosifov's avatar
kristinajosifov
New Contributor
7 years ago
Copy LinkReport

Hi,
Try this in SQL Server Execute snap for date output:
SELECT CONVERT(varchar(10),(select replace(‘2018-09-17T14:42:22.480’,‘T’,’ ‘)), 105)
or date and time output:
SELECT CONVERT(varchar(19),(select replace(‘2018-09-17T14:42:22.480’,‘T’,’ ')), 105)
Regards.

  • alchemiz's avatar
    alchemiz
    Contributor III
    3 years ago
    Copy LinkReport

    Hi @heidi.andrew,

    Good day, you can always put each fixed with formatter in a different pipeline (child pipeline) then from the parent pipeline have a list of all the child pipeline that needs to be executed output view of the pipeline execute needs to be set to binary then link the file writer

    In any case, here’s a pipeline that will stream the content as document then convert back to binary for file writer

    Hope this helps…

    ~EmEm