Forum Discussion

Harsha3's avatar
Harsha3
New Contributor III
6 years ago

Date formatting

Hi , I am trying to convert a local-date-time format to dd-MMM-yy ( say for eg :13-NOV-19). I tried various methods still could not achieve this . It could be useful if I have a method to achieve...
mmussitsch's avatar
mmussitsch
New Contributor II
4 years ago

Well according to support, the snowflake Timestamp_NTZ is not compatible with snaplogic expression language. Only work around is to use a string field instead if possibe. If not in the database, then write it out to a file without manipulation and then read it in as a string in snaplogic. Not ideal, but I think candidate for snaplogic enhancement request.

Thanks again for the help.

  • del's avatar
    del
    Contributor III
    4 years ago

    @mmussitsch,

    As an alternative to writing/reading a JSON file, try this (or similar expression as-needed) in your mapper using the JSON parse() and stringify() in combination:

    JSON.parse(JSON.stringify($LAST_RUN_DATE))
    or
    JSON.parse(JSON.stringify($LAST_RUN_DATE.Timestamp))

    While I don’t have access to the Snowflake Timestamp_NTZ type to test, I’ve tested this on a SQL Server DateTime2 field (which is also an incompatible local-date-time) and it converts its value to a string type.