Shrabanti
New Contributor II
Joined 5 years ago
User Profile
User Widgets
Contributions
Re: Dynamically taking S3 path from metadata
I have passed the value from parent.I can see the value in json I have declared pipeline parameter in child pipeline 3.But in s3 file reader I am not getting the value I am passing. Is it something wrong I am doing here? Thanks & Regards, SHrabanti3KViews0likes2CommentsNeed help withTime format Conversion
Hi All, I am trying change a date format with expression. Input is a string value: “04/23/2021 12:00:00 AM” Output should be ‘yyyy-MM-dd HH:mm:ss’ format I am trying data parse the incoming date format but unable find proper format for input date. Date.parse($CertActivityDate,“mm/dd/yyyy hh:mm:ss AM”).toLocaleDateTimeString( { “format”:“yyyy-MM-dd HH:mm:ss” } ) Could you please siggest.3.7KViews0likes4CommentsTime format Conversion changing the date
I am doing date conversion. But not sure why it is changing the date. Input Date is : “29-JUN-21 10.07.35.000000 AM” Output date is becoming :“2020-12-27 10:07:35” The conversion I am using is : Date.parse($OrderDetailCreateDate,“dd-MMM-YY hh.mm.ss.SSSSSS aa”).toLocaleDateTimeString( { “format”:“yyyy-MM-dd HH:mm:ss” } )2.3KViews0likes2CommentsTime format Conversion not working
Hi All, I am trying change a data format with expression. Input is a string value: “9-JUN-21 10.06.39.000000 AM” Output should be ‘yyyy-MM-dd HH:mm:ss’ format I am trying data parse the incoming date format but unable find proper format for input date. Date.parse($OrderDetailUpdateDate,“dd-MMM-yyyy’ 'HH:mm:ss.SSSXXX AM”).toLocaleDateTimeString({“format”:“yyyy-MM-dd HH:mm:ss”}) Could you please siggest.Unable to execute Redshift Script with comments in it using Redshift Execute
Hi All, I am using redshift execute to run a redshift script . While I am able to run the script when every redshift query is enclosed in double quote, but the script is failing when I am adding comments to that. Would like to know how to write comment in redshift script so that it can be acceptable in “Redshift Execute”.2.9KViews0likes2Comments