Try casting to equivalent data types. For example
SELECT CAST(GETDATE() AS date)
SELECT CAST(GETDATE() AS time)
If you want to separate them on the C# side, read the data into a
DateTime[
^] variable and use either
-
DateTime.Date Property (System) | Microsoft Docs[
^]
- or
DateTime.TimeOfDay Property (System) | Microsoft Docs[
^]
As a side note, breaking the date and time into separate columns when inserting a row might not be a good idea. You can always split the information needed from a single column so adding two separate columns for a single point-in-time makes things unnecessary complicated.