Filed under: ETL
During an insert step in Scribe Workbench, I wanted to populate a CreatedDateTime field with the current time. This field is a datetime2 in the SQL server. So I put in NOW( ) like this:
But, instead of capturing a timestamp and putting it in, I got the following error in the execution log:
Change NOW( ) to the following: TEXT( NOW( ), “MM-dd-YYYY hh:mm:ss”)
This will take the value captured from the NOW( ) as a string and convert it into type datetime2. No more errors! 🙂
No comment yet, add your voice below!