How to get time for a date in 23:59:59 format

Question

1.00/5 (1 vote)

See more:

I have a column date which has the values with date and its coressponding time stamp
but the query with which I am querying the table has a between which has 2 date values

eg 2014-06-24 00:00:00 and 2014-06-26 00:00:00

So the query retrieves the result only for 24,25 but not for 26 as the time is for midnight.
So is there any way to convert 00:00:00 in date2 to 23:59:59 using C#

Posted 26-Jun-14 23:22pm

VipinKumar Maurya

Updated 20-Apr-21 23:34pm

Add a Solution

Comments

ArunRajendra 27-Jun-14 5:28am

Post the code what you have tried.

5 solutions

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)

Peter Leow · Answer 1 · 2014-06-26T23:25:00

Solution 1

Refer: convert-datetime-time-from-000000-to-235959[^]

Posted 26-Jun-14 23:25pm

Peter Leow

Comments

VipinKumar Maurya 27-Jun-14 5:30am

That what I am not getting it. How to do it?

Nayan Rudani · Answer 2 · 2014-06-27T00:55:00

Solution 4

you may try with

C#

toDate.ToString("yyyy-MM-dd 23:59:59.000");

SQL

DECLARE @Time TIME = '23:59:59.999'
SELECT dateColumn + CAST(@Time as DATETIME)
FROM tableName

Posted 27-Jun-14 0:55am

Nayan Rudani

Comments

VipinKumar Maurya 28-Jun-14 2:36am

Thanks to all. I got my work done

DamithSL · Answer 3 · 2014-06-26T23:37:00

Solution 2

assume you have two date times as parameters to your search method, for example startdt, enddt
what you can do is, set end date by adding one day like below

C#

enddt = enddt.AddDays(1);

now call your function with startdt, enddt

Posted 26-Jun-14 23:37pm

DamithSL

Updated 26-Jun-14 23:38pm

v2

Marcin Kozub · Answer 4 · 2014-06-27T00:45:00

Solution 3

Some time ago I've answered similar question. Simples way is to forget about Time part and use only date part. Maybe my solution will help you:

how to query for date in between for window forms in c#[^]

Posted 27-Jun-14 0:45am

Marcin Kozub

Updated 27-Jun-14 0:47am

v2

Member 15162685 · Answer 5 · 2021-04-20T23:34:00

Solution 5

Declare two DateTime variables as below:

C#

DateTime dtFromDate = DateTime.Now.Date;// You will get date as DD-MM-YYYY 12:00:00 AM
DateTime dtFrom  =DateTime.Now.AddDays(1).Date.AddSeconds(-1);// You will get date as DD-MM-YYYY 23:59:59 PM

Posted 20-Apr-21 23:34pm

Member 15162685