How to capture the date timestamp in Snowflake database in a C# console application?

Asked Jun 09 '21 at 08:42

Active Jun 09 '21 at 09:05

Viewed 126 times

So I want to capture these two columns (datatype- timestamp) into a variable in C#. enter image description here

I have captured the other variables of string datatype like this to which it gives correct output

                string query_id = reader.GetString(11);
                string task_name = reader.GetString(0);
                string database_name = reader.GetString(5);
                string schema_name = reader.GetString(3);

How do I capture the timestamps into a variable as reading by string doesn't give the correct column?

edited Jun 09 '21 at 09:05

Fildor

14,510
4
35
67

asked Jun 09 '21 at 08:42

Karthik Desai

Is there a `GetDateTime`? Or `GetDateTimeOffset`? – Fildor Jun 09 '21 at 09:06
https://learn.microsoft.com/en-us/dotnet/api/system.data.sqlclient.sqldatareader.getdatetimeoffset?view=dotnet-plat-ext-5.0 – Mitch Wheat Jun 09 '21 at 09:08

How to capture the date timestamp in Snowflake database in a C# console application?

0 Answers0