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 column currently looks like this (I couldn’t cut/paste for some reason):
2018-09-17T14:42:22.480

I thought by selecting ‘translate date and time types’ in my Excel Formatter snap would have done the trick but apparently not. What am I missing?

1 Reply

  • 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.