yes1819
New Contributor III
Joined 5 years ago
User Profile
User Widgets
Contributions
Adding system datetime when insert data into Redshift
Hi, I've added mapper expression to add system datetime when I insert data to Redshift table. It ran ok, but the problem is, it inserted different time for each rows. How can I get date and time that only shows only one same date and time (either pipeline execution start time or end time) so that all rows those are being inserted at the same time will have the same date and timestamped?Re: S3 file upload with TODAY'S date in the file name
Thank you so much Miller. Your code was working ok, but it saved file with some weird date. In the screenshot, the first file is with your code, and saved as 2023-04-12 instead of 2023-12-12 Below 2 files are saved with Date.now() and their date is ok. Do you think you can figure out why it saved the file as 2023-04-12? The last screenshot is the new snap that I used your code. Thank you so much! Date.now().toLocaleDateString({"format":"yyyy-mm-dd"})
