Forum Discussion

Bmorechick27's avatar
Bmorechick27
New Contributor
7 years ago

Formatting date/time in Excel formatter

I’m new to snapLogic and can’t figure out how to format my date/time column in an Excel spreadsheet. I have a SQL Server Execute pipeline that emails output in an Excel spreadsheet to my user. The co...
kristinajosifov's avatar
kristinajosifov
New Contributor
7 years ago

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)
Regards.