This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi,
Try this in SQL Server Execute snap for date output:
SELECT CONVERT(varchar(10),(select replace(‘2018-09-17T14:42:22.480’,‘T’,’ ‘)), 105)
or date and time output:
SELECT CONVERT(varchar(19),(select replace(‘2018-09-17T14:42:22.480’,‘T’,’ ')), 105...
Hi Drew,
In the new release there is a simple way to encode or decode strings into and from HTML entities with HTML.encode()/decode() functions.
https://docs-snaplogic.atlassian.net/wiki/spaces/SD/pages/797704355/HTML+-+Encode+and+Decode+Functions
Re...