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.