How-to-simply...

Convert NodaTime Instant stored as BIGINT in SQL field to human-readable Date

  • 1 DATEADD(Ms,[NodaTimeInstantBigintColName]/10000%(3600*24*1000), DATEADD(Day,[NodaTimeInstantBigintColName]/10000/(3600*24*1000),'1970-01-01 00:00:00.0'))