public void SnowflakeDate_ToDateTime(string sfDate, string expectedDateTimeString)
{
var expectedDateTime = DateTime.ParseExact(expectedDateTimeString, "yyyy-MM-dd", CultureInfo.InvariantCulture);
var convertedResult = SnowflakeTypesConverter.ConvertToDateTime(sfDate, "date");
Assert.AreEqual(expectedDateTime, convertedResult);
}
public void SnowflakeTime_ToDateTime(string sfTime, string expectedDateTimeString)
{
var expectedDateTime = DateTime.ParseExact(expectedDateTimeString, "yyyy-MM-dd HH:mm:ss.fffffff", CultureInfo.InvariantCulture);
var convertedResult = SnowflakeTypesConverter.ConvertToDateTime(sfTime, "time"); // same conversion as for "timestamp_ntz"
Assert.AreEqual(expectedDateTime, convertedResult);
}