C#•9mo ago

✅ Creating a datetime with a timezone

How do I create a DateTime with new DateTime(2010, 05, 12); and give it a specific TimeZoneInfo

19 Replies

I dont think DateTime can hold time zone that would be DateTimeOffset best u can get would be doing UTC and then using TimeZoneInfo

khamasOP•9mo ago

yeah got it, but then how would I get the time of the first day of the month? I'd want to get like 01/03/2024 at 00:00 in the specific timezone

leowest•9mo ago

get as in what sense? querying a db? just represent it in the datatime object or what? because if you're getting it from the db u would be doing so in UTC as well so I dont see the problem

Pobiega•9mo ago

var tzi = TimeZoneInfo.Local; // set to whatever timezone you want.

var x = new DateTimeOffset(2010, 05, 12, 0, 0, 0, tzi.BaseUtcOffset);

var tzi = TimeZoneInfo.Local; // set to whatever timezone you want.

var x = new DateTimeOffset(2010, 05, 12, 0, 0, 0, tzi.BaseUtcOffset);

khamasOP•9mo ago

in DB and server side it would be UTC, just that the clients work on their own time zone

leowest•9mo ago

ok and what db is it?

khamasOP•9mo ago

postgres

leowest•9mo ago

so it uses DateTimeOffset

khamasOP•9mo ago

anyways DB doesn't matter, it's all UTC there is no need for offset I just want the client app to have it's own timezone and I'll convert to UTC when sending to server

leowest•9mo ago

sure then u would just use TimeZoneInfo to offset it

khamasOP•9mo ago

say like I want to gather reports from 01/01/2024 to 31/01/2024 as CEST time

Unknown User•9mo ago

Message Not Public

khamasOP•9mo ago

and DTO can output me a DT as UTC anyways

Unknown User•9mo ago

Message Not Public

khamasOP•9mo ago

alright

Unknown User•9mo ago

Message Not Public

MODiX•9mo ago

TeBeCo

using System;

var rstTimeZoneInfo = TimeZoneInfo.FindSystemTimeZoneById("Romance Standard Time");
var localTime = new TimeOnly(13, 30, 0);

Console.WriteLine(GetFormatedFutureLocatedDateTime(new DateOnly(2023, 01, 28), localTime , rstTimeZoneInfo ));
Console.WriteLine(GetFormatedFutureLocatedDateTime(new DateOnly(2023, 03, 28), localTime , rstTimeZoneInfo ));

string GetFormatedFutureLocatedDateTime(DateOnly localDate, TimeOnly localTime, TimeZoneInfo rstTimeZoneInfo)
{
  var unknownDateTime = localDate.ToDateTime(localTime);
  
  var rstOffset = rstTimeZoneInfo.GetUtcOffset(unknownDateTime);
  var targetDateTimeOffset = new DateTimeOffset(unknownDateTime, rstOffset);

  return targetDateTimeOffset.ToString("yyyy-MM-ddTHH:mm:ddK");
}

using System;

var rstTimeZoneInfo = TimeZoneInfo.FindSystemTimeZoneById("Romance Standard Time");
var localTime = new TimeOnly(13, 30, 0);

Console.WriteLine(GetFormatedFutureLocatedDateTime(new DateOnly(2023, 01, 28), localTime , rstTimeZoneInfo ));
Console.WriteLine(GetFormatedFutureLocatedDateTime(new DateOnly(2023, 03, 28), localTime , rstTimeZoneInfo ));

string GetFormatedFutureLocatedDateTime(DateOnly localDate, TimeOnly localTime, TimeZoneInfo rstTimeZoneInfo)
{
  var unknownDateTime = localDate.ToDateTime(localTime);
  
  var rstOffset = rstTimeZoneInfo.GetUtcOffset(unknownDateTime);
  var targetDateTimeOffset = new DateTimeOffset(unknownDateTime, rstOffset);

  return targetDateTimeOffset.ToString("yyyy-MM-ddTHH:mm:ddK");
}

2023-01-28T13:30:28+01:00
2023-03-28T13:30:28+02:00
                     ^

2023-01-28T13:30:28+01:00
2023-03-28T13:30:28+02:00
                     ^

Quoted by

<@689473681302224947> from #web (click here)

React with ❌ to remove this embed.

khamasOP•9mo ago

ok so I'll just create an offset based on a DateOnly

wasabi•9mo ago

Worht mentioning that offset isn't a timezone, for all of the pedantics out there. That's a lossy conversion going from one to the other.

Gaming

Programming

✅ Creating a datetime with a timezone