How to compare HHmm against HHmm of today current time

Question

1.00/5 (1 vote)

See more:

I have a table that has int datatype to save 4 digits that represent for HHmm. I fetch 4 digits from database, and returns to me in this plain format 1130, no colon between 11 and 30 and no AM or PM. After that, I want to compare with HHmm from today datetime's components in 'if statement', and below are codes.

I fetched 4digits from table as below by creating datatable.

C#

int sTime = Convert.ToInt32(dr["SendTime"].ToString())

It returns as 1130

Then, I called today datetime and formatted as HHmm like this.

C#

DateTime TodayHrMin = DateTime.Now; //Get today's date and time
string todayHourMin = TodayHrMin.ToString("HHmm"); //Convert today's date and time to string format
int iHourMin = Convert.ToInt32(todayHourMin);//convert to int so that it can compare with int sTime

When I compare these two values (sTime and iHourMin) in if statement and do some action, it is not doing any action in if statement. Is there a way to solve this by using proper date and time formatting. I started learning asp .net a few months ago and not so much experienced in writing codes.. Thank.

Posted 28-Aug-14 16:11pm

Member 10858162

Add a Solution

2 solutions

Solution 1

Wrong approach. Don't manipulate strings representing data, manipulate data. Don't compare strings, don't compare integers representing time, compare the objects of System.DateTime type. Try to avoid using strings, but if some data comes from strings, parse it first, and then compare.
Please see all the methods named Parse, ParseExact, TryParse and TryParseExact:
http://msdn.microsoft.com/en-us/library/system.datetime%28v=vs.110%29.aspx[^].

For comparison, use the operators defined for this type: '==', '>=', '<=', '<', '>', '-'.

—SA

Posted 28-Aug-14 17:35pm

Sergey Alexandrovich Kryukov

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

debashishPaul · Accepted Answer · 2014-08-28T20:38:00

DateTime has properties to get its Hour and Minute values.

Why don't you try this?

CSS

int DBTime = 1130;


//Parse DB Hour and Minute
int hour = DBTime / 100;
int minute = DBTime % 100;

DateTime TodayHrMin = DateTime.Now; //Get today's date and time
int todayHour = TodayHrMin.Hour; //today's Hour
int todayMinute = TodayHrMin.Minute; //today's Minute

//TODO: Your Logic

or you can do it in the other way:

C#

DateTime TodayHrMin = DateTime.Now; //Get today's date and time

int todayHour = TodayHrMin.Hour; //today's Hour
int todayMinute = TodayHrMin.Minute; //today's Minute

//Parse DB Hour and Minute
int TodayDBFormattedTime = (todayHour * 100) + todayMinute;

//TODO: Your Logic