Stored in a SQL table is a date/time field and it is defined as:
CreationDateTime datetime2(7) allow nulls and has stored in it 2023-06-06 09:28:37.6271104.
I have never processed a datetime beyond the standard MM/dd/yyyy hh:mm:ss. When I read the field from the databse table:
creationDateTime = Reader["CreationDateTime"].ToString();
all I get is 2023-06-06 09:28:37 and not the 2023-06-06 09:28:37.6271104.
What I have tried:
I have tried everything but nothing works. What am I doing wrong? Thanks in advance for the help?