How to Covert date in the JSON data
Hello,
I am trying to work with the date (timestamp to be precise) and getting into trouble. My requirement is below.
I have a stage table where the data is stored as JSON in a Variant Column and...
Forum Discussion
I suggest not trying to do this in SQL. Just get the datetime as a string, and use a Mapper expression to do the date manipulation using the SnapLogic expression language.
