Month: September 2017

Scribe Workbench: Conversion failed when converting date and/or time from character string.


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”)

Like this:


This will take the value captured from the NOW( ) as a string and convert it into type datetime2. No more errors! 🙂

Filed under: ETL