It might not be the operating system as much as the language and the resulting default conversions which are at play here. To consistently format a date-time consider using the "Get System Info" transform for the system date, and the "Select Values (meta tab)" transform for the conversion. There are date-time masks as examples in the format column.
Good luck, Matt Op vr 25 aug. 2023 09:10 schreef Eric <[email protected]>: > Hi, > > In a pipeline, I generate a variable using JavaScript called "idprocess," > which is the current date and time in milliseconds. Then, I perform the > "Set Variable" transformation and refer to that variable as "IDPROCESS." > In the main workflow, I call that pipeline and subsequently execute an SQL > script where I perform an insert into the database using the "IDPROCESS" > variable: > > INSERT INTO camerfirma.ctl_process (idprocess, status, fecha_inicio, > fecha_fin) > VALUES (${IDPROCESS}, 'In Progress', NOW(), null); > > On Windows, this script functions correctly and inserts the "idprocess" > into the database. However, on Linux, I encounter the following error: > > SQL - ERROR: syntax error at or near "$" > > Thanks. > > El vie, 25 ago 2023 a las 1:02, Diego Mainou (< > [email protected]>) escribió: > >> Hi Eric, >> >> You'll need to give us more info >> >> >> <https://www.bizcubed.com.au> Diego Mainou >> Product Manager >> M. +61 415 152 091 >> E. [email protected] >> www.bizcubed.com.au <https://www.bizcubed.com.au> >> >> ------------------------------ >> *From: *"Eric" <[email protected]> >> *To: *"users" <[email protected]> >> *Sent: *Friday, 25 August, 2023 5:01:15 AM >> *Subject: *Problem in Linux >> >> Hello >> >> >> >> I’ve been experiencing issues on Linux. I’ve developed an ETL process in >> witch I generate a variable that i subsequently use for an INSERT operation >> using an SQL script. It Works fine on Windows, but on Linux the variable is >> not recognized. What could be the issue? >> >> >> >> Thanks >> >> >> >>
