Strip seconds from datetime

Question

I want to strip/remove seconds from a DateTime. Starting with a full Datetime like:

DateTime datetime = DateTime.UtcNow;

I want to strip the seconds using any inbuilt function or regular expression.

Input: 08/02/2015 09:22:45

Expected result: 08/02/2015 09:22:00

i want to expected 08/02/2015 09:22:45 then want to get result only 08/02/2015 09:22:00 — Deependra Singh, Jul 23 '15 at 04:53
I've inlined some comment you've made into body of the post. Please edit the post yourself to update/clarify if necessary. — Alexei Levenkov, Jul 23 '15 at 05:12
Possible duplicate of [How to truncate milliseconds off of a .NET DateTime](https://stackoverflow.com/questions/1004698/how-to-truncate-milliseconds-off-of-a-net-datetime) — Joel Bourbonnais, Mar 29 '18 at 19:41

score 54 · Answer 1 · edited Oct 25 '21 at 19:45

54

You can create a new instance of date with the seconds set to 0.

DateTime a = DateTime.UtcNow;
DateTime b = new DateTime(a.Year, a.Month, a.Day, a.Hour, a.Minute, 0, a.Kind);

Console.WriteLine(a);
Console.WriteLine(b);

edited Oct 25 '21 at 19:45

shashwat

7,495
8
55
87

answered Jul 23 '15 at 05:04

Mike Hixson

4,773
1
17
24

1

For consistency, I suggest you either use DateTime.Now for creating "a", or add "DateTimeKind.Utc" to the end of the line creating "b". Creating a UTC time without adding the timezone is likely to cause some strange results. – Patrick M Oct 31 '18 at 17:41
to complete Patrick comment, use the ctor with DataTimeKind, so DateTime b = new DateTime(a.Year, a.Month, a.Day, a.Hour, a.Minute, 0, DateTimeKind.Utc); as I just edited – EricBDev May 21 '19 at 13:25
This does not strip the seconds from the result either. It only sets them to 0. – IOviSpot Dec 26 '21 at 11:14
This was safe direct and easy readable journey and got me there. – Honza P. Feb 11 '22 at 15:47

score 50 · Accepted Answer · answered Jul 23 '15 at 05:03

50

You can do

DateTime dt = DateTime.Now;
dt = dt.AddSeconds(-dt.Second);

to set the seconds to 0.

answered Jul 23 '15 at 05:03

ChrisC73

1,747
13
14

41

Careful: this will NOT strip the milliseconds from the DateTime. – Métoule Feb 13 '18 at 13:25
8

Careful:Even if you do .AddMilliseconds(-dt.Millisecond) there will still be fractions of a millisecond left over. – AlexDev Mar 07 '19 at 20:51
1

I believe this will remove the milliseconds (and fractions of a millisecond). dt= dt.AddTicks(-(dt.Ticks % TimeSpan.TicksPerSecond)); – Clownish Carnage Jun 20 '20 at 03:22

clamchoda · Answer 3 · 2020-03-06T21:51:11.340

12

DateTime is actually stored separately as a Date and a TimeOfDay. We can easily re-initialize the date without including the seconds in the TimeSpan initialization. This also ensures any leftover milliseconds are removed.

date = date.Date + new TimeSpan(date.TimeOfDay.Hours, date.TimeOfDay.Minutes, 0);

edited Mar 06 '20 at 21:51

answered Oct 29 '19 at 23:54

clamchoda

3,427
2
33
69

AlliterativeAlice · Answer 4 · 2020-12-13T00:14:27.050

7

A simple solution which strips both seconds and milliseconds from a DateTime:

DateTime dt = DateTime.Now;
DateTime secondsStripped = dt.Date.AddHours(dt.Hour).AddMinutes(dt.Minute);

edited Dec 13 '20 at 00:14

answered Feb 12 '20 at 23:24

AlliterativeAlice

10,893
8
45
68

blackforest-tom · Answer 5 · 2019-03-19T16:14:21.147

5

How about this rather elegant solution?

new DateTime(DateTime.UtcNow.Ticks / 600000000 * 600000000)

... which will also strip any milli/micro/nanoseconds.

edited Mar 19 '19 at 16:14

answered Feb 25 '19 at 09:03

blackforest-tom

428
4
8

There's an extra 0 there. You mean / 10_000_000. – AlexDev Mar 07 '19 at 21:00
The question was about stripping seconds off a DateTime. But you were right about something being wrong. There are 60 seconds in a minute, not 100 ;) I fixed the answer. By the way: you might wanna update your answer too, since its wrong (not stripping off seconds). Also the syntax error (the underscores) aren't too obvious for junior coders. – blackforest-tom Mar 19 '19 at 16:15
ok. since I didn't see a 6 I thought you were trying to strip the milliseconds. – AlexDev Mar 20 '19 at 12:05

score 2 · Answer 6 · edited Mar 09 '18 at 20:39

2

DateTime time = DateTime.Now;
string timestring = time.ToString("g");

ToString("g") will convert DateTime to string and remove seconds.

Output: 03/29/2018 11:11 PM

edited Mar 09 '18 at 20:39

Harun Diluka Heshan

1,079
2
18
28

answered Mar 09 '18 at 17:24

Pirate

1,103
1
8
18

You'd have to parse it back to a DateTime though to be compliant with OP's request to get a DateTime, not a string. – Sep 08 '19 at 12:28

score 2 · Answer 7 · edited Sep 08 '19 at 11:41

// 2.3 - 0.3 = 2.0
public static DateTime Floor(this DateTime value, TimeSpan interval) {
    var mod = value.Ticks % interval.Ticks;
    return value.AddTicks( -mod );
}

// 2.3 - 0.3 + 1 = 3.0
public static DateTime Ceil(this DateTime value, TimeSpan interval) {
    var mod = value.Ticks % interval.Ticks;
    if (mod != 0) return value.AddTicks( -mod ).Add( interval );
    return value;
}

score 2 · Answer 8 · answered Mar 24 '21 at 21:35

2

And as an extension, keeps the kind and also trims milliseconds

public static DateTime TrimSeconds(this DateTime a)
{
    return new DateTime(a.Year, a.Month, a.Day, a.Hour, a.Minute, 0, a.Kind);
}

answered Mar 24 '21 at 21:35

BobbyTables

4,008
1
27
35

This does not strip the seconds from the result either. It only sets them to 0. – IOviSpot Dec 26 '21 at 11:15
@wEight And what happens to the zeroes in the original questions sample of the expexted results? I dont think anyone expects them to be "gone" from a DateTime – BobbyTables Dec 27 '21 at 07:57

AlexDev · Answer 9 · 2019-03-20T12:08:04.580

1

To get a local time you can use:

var dt = DateTime.Now;
dt = dt.AddTicks(-(dt.Ticks % (60 * 10_000_000)));

edited Mar 20 '19 at 12:08

answered Mar 08 '19 at 12:02

AlexDev

3,445
27
35

Strip seconds from datetime

9 Answers9

Linked

Related