Compare Date C# and SQL Server

Question

How can I compare Date ([now] day, month, year, hour, minute) and data from two columns? The first column has date only like "2020-01-01" and second column for same row has data like "15:30:00" and this column datatype is time7.

I need to check if ([now] day, month, year, hour, minute) > from this two columns to do something.

this is data from data base

I need to compare it in client side in C#

date column time column ---------------- || -------------------- 2020-01-01 || 15:50:00 this data in Data Base i need when i check now like 2020-04-08 00:36:00 then date in database less do something — Haytham Abd Elghany
– Haytham Abd Elghany, Commented Apr 7, 2020 at 22:34
Please edit and additional information direction into the question - don't add as comments. — Dale K
– Dale K, Commented Apr 7, 2020 at 22:38
Are you trying to compare the values on the database side in SQL, or on the client side in C#? — AlwaysLearning
– AlwaysLearning, Commented Apr 7, 2020 at 22:46

Nenad · Accepted Answer · 2020-04-07 22:50:41Z

1

You can combine date part and time part into single datetime like this:

var time = TimeSpan.Parse("15:30:00", System.Globalization.CultureInfo.InvariantCulture);
var date = DateTime.Parse("2020-01-01", System.Globalization.CultureInfo.InvariantCulture);

var dateTime = date.Add(time);

if (DateTime.Now > dateTime)
{
    // TODO
}

answered Apr 7, 2020 at 22:50

Nenad

27k11 gold badges81 silver badges102 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

mjwills Over a year ago

I'd strongly recommend doing this in the database query instead @HaythamAbdElghany.

Filburt · Accepted Answer · 2020-04-07 23:06:37Z

0

You can solve the issue at the source and introduce a computed column:

CREATE TABLE [dbo].[whatever]
(
    [that_day] CHAR(10) NULL, 
    [that_time] CHAR(8) NULL, 
    [day_time] AS TRY_CONVERT(datetime2, that_day + ' ' + that_time) 
)

However this should only be the first step and fix the anti-pattern of storing date and time information as text in your database.

answered Apr 7, 2020 at 23:06

Filburt

18.1k14 gold badges106 silver badges167 bronze badges

1 Comment

Haytham Abd Elghany Over a year ago

thank you Filburt for your answer, but i don`t need update table in database i just want process it on the client side in C# and Nenad answer it helped , thanks any way

Collectives™ on Stack Overflow

Compare Date C# and SQL Server

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related