linux 时区 0900是哪,c＃-解析DateTime的时区为PST / CEST / UTC /

c＃-解析DateTime的时区为PST / CEST / UTC /

我正在尝试解析类似于以下内容的国际日期时间字符串：

24-okt-08 21:09:06 CEST

到目前为止，我有类似的东西：

CultureInfo culture = CultureInfo.CreateSpecificCulture("nl-BE");

DateTime dt = DateTime.ParseExact("24-okt-08 21:09:06 CEST",

"dd-MMM-yy HH:mm:ss ...", culture);

问题是我应该对格式字符串中的“ ...”使用什么？ 查看“自定义日期和时间格式字符串” MSDN页面似乎没有以PST / CEST / GMT / UTC格式列出用于解析时区的格式字符串。

6个解决方案

32 votes

AFAIK无法识别时区缩写。 但是，如果用时区偏移量代替缩写，那就可以了。 例如。：

DateTime dt1 = DateTime.ParseExact("24-okt-08 21:09:06 CEST".Replace("CEST", "+2"), "dd-MMM-yy HH:mm:ss z", culture);

DateTime dt2 = DateTime.ParseExact("24-okt-08 21:09:06 CEST".Replace("CEST", "+02"), "dd-MMM-yy HH:mm:ss zz", culture);

DateTime dt3 = DateTime.ParseExact("24-okt-08 21:09:06 CEST".Replace("CEST", "+02:00"), "dd-MMM-yy HH:mm:ss zzz", culture);

Panos answered 2020-07-24T18:23:05Z

22 votes

快速的答案是，您无法做到。

这就是为什么

有一个世界时区的权威数据库，您可以从IANA那里获取。

问题是3或4个字母的缩写与IANA时区具有多对一关联。 例如"CST"的含义不同，这取决于您的文化，所处的世界以及应用程序的上下文。

AMT "Armenia Time" Asia UTC + 4 hours

AMT "Amazon Time" South America UTC - 4 hours

如果您真的想解决这个问题，建议您使用Noda Time代表您的"CST"s。 您必须编写一些代码将缩写词转换为标准IANA时区。

我们无法为您完成此操作，这取决于您应用程序的上下文。

另一个很好的例子是"CST"。

CST "China Standard Time" Asia UTC + 8 hours

CST "Central Standard Time" Central America UTC - 6 hours

CST "Cuba Standard Time" Caribbean UTC - 5 hours

CST "Central Standard Time" North America UTC - 6 hours

Jodrell answered 2020-07-24T18:23:52Z

9 votes

如果您决定走搜索与替换路线的缩写字典(我这样做了)。

Dictionary _timeZones = new Dictionary() {

{"ACDT", "+1030"},

{"ACST", "+0930"},

{"ADT", "-0300"},

{"AEDT", "+1100"},

{"AEST", "+1000"},

{"AHDT", "-0900"},

{"AHST", "-1000"},

{"AST", "-0400"},

{"AT", "-0200"},

{"AWDT", "+0900"},

{"AWST", "+0800"},

{"BAT", "+0300"},

{"BDST", "+0200"},

{"BET", "-1100"},

{"BST", "-0300"},

{"BT", "+0300"},

{"BZT2", "-0300"},

{"CADT", "+1030"},

{"CAST", "+0930"},

{"CAT", "-1000"},

{"CCT", "+0800"},

{"CDT", "-0500"},

{"CED", "+0200"},

{"CET", "+0100"},

{"CEST", "+0200"},

{"CST", "-0600"},

{"EAST", "+1000"},

{"EDT", "-0400"},

{"EED", "+0300"},

{"EET", "+0200"},

{"EEST", "+0300"},

{"EST", "-0500"},

{"FST", "+0200"},

{"FWT", "+0100"},

{"GMT", "GMT"},

{"GST", "+1000"},

{"HDT", "-0900"},

{"HST", "-1000"},

{"IDLE", "+1200"},

{"IDLW", "-1200"},

{"IST", "+0530"},

{"IT", "+0330"},

{"JST", "+0900"},

{"JT", "+0700"},

{"MDT", "-0600"},

{"MED", "+0200"},

{"MET", "+0100"},

{"MEST", "+0200"},

{"MEWT", "+0100"},

{"MST", "-0700"},

{"MT", "+0800"},

{"NDT", "-0230"},

{"NFT", "-0330"},

{"NT", "-1100"},

{"NST", "+0630"},

{"NZ", "+1100"},

{"NZST", "+1200"},

{"NZDT", "+1300"},

{"NZT", "+1200"},

{"PDT", "-0700"},

{"PST", "-0800"},

{"ROK", "+0900"},

{"SAD", "+1000"},

{"SAST", "+0900"},

{"SAT", "+0900"},

{"SDT", "+1000"},

{"SST", "+0200"},

{"SWT", "+0100"},

{"USZ3", "+0400"},

{"USZ4", "+0500"},

{"USZ5", "+0600"},

{"USZ6", "+0700"},

{"UT", "-0000"},

{"UTC", "-0000"},

{"UZ10", "+1100"},

{"WAT", "-0100"},

{"WET", "-0000"},

{"WST", "+0800"},

{"YDT", "-0800"},

{"YST", "-0900"},

{"ZP4", "+0400"},

{"ZP5", "+0500"},

{"ZP6", "+0600"}

};

Jussi Palo answered 2020-07-24T18:24:12Z

3 votes

我有两个答案，因为我不确定您要问什么。

1)我看到您正在使用CultureInfo，所以如果您只想格式化特定于文化的日期和时间，我将日期/时间和时区分开，在日期/时间上应用文化方法并附加时区。 如果“ CEST”因不同的文化而不同，则您必须通过列出所有选项来更改它(可能在案例声明中)。

2)如果您想将日期/时间转换为其他时区，则不能使用CultureInfo，

我建议阅读：[http://msdn.microsoft.com/en-us/library/ms973825.aspx]

您还可以使用.net Framework 3.5类TimeZoneInfo(与TimeZone不同)来简化生活。

[HTTP://MSDN.Microsoft.com/恩-US/library/system.timezone info.aspx]

hmak answered 2020-07-24T18:24:55Z

0 votes

这是这样的：

获取字符串(前提条件：格式：ddd，dd MMM yyyy HH：mm：ss zzz)

获取最后一个空格

从字符串中删除zzz，但保存zzz的值

zzz的查询偏移量

向字符串添加偏移量

string dateString = reader.ReadContentAsString();

int timeZonePos = dateString.LastIndexOf(' ') + 1;

string tz = dateString.Substring(timeZonePos);

dateString = dateString.Substring(0, dateString.Length - tz.Length );

dateString += s_timeZoneOffsets[tz];

// https://msdn.microsoft.com/en-us/library/w2sa9yss(v=vs.110).aspx

//string es = reader.ReadElementString("pubDate");

this.m_value = System.DateTime.ParseExact(dateString, "ddd, dd MMM yyyy HH:mm zzz", System.Globalization.CultureInfo.InvariantCulture);

与

private static System.Collections.Generic.Dictionary s_timeZoneOffsets =

new System.Collections.Generic.Dictionary() {

{"ACDT", "+10:30"},

{"ACST", "+09:30"},

{"ADT", "-03:00"},

{"AEDT", "+11:00"},

{"AEST", "+10:00"},

{"AHDT", "-09:00"},

{"AHST", "-10:00"},

{"AST", "-04:00"},

{"AT", "-02:00"},

{"AWDT", "+09:00"},

{"AWST", "+08:00"},

{"BAT", "+03:00"},

{"BDST", "+02:00"},

{"BET", "-11:00"},

{"BST", "-03:00"},

{"BT", "+03:00"},

{"BZT2", "-03:00"},

{"CADT", "+10:30"},

{"CAST", "+09:30"},

{"CAT", "-10:00"},

{"CCT", "+08:00"},

{"CDT", "-05:00"},

{"CED", "+02:00"},

{"CET", "+01:00"},

{"CEST", "+02:00"},

{"CST", "-06:00"},

{"EAST", "+10:00"},

{"EDT", "-04:00"},

{"EED", "+03:00"},

{"EET", "+02:00"},

{"EEST", "+03:00"},

{"EST", "-05:00"},

{"FST", "+02:00"},

{"FWT", "+01:00"},

{"GMT", "+00:00"},

{"GST", "+10:00"},

{"HDT", "-09:00"},

{"HST", "-10:00"},

{"IDLE", "+12:00"},

{"IDLW", "-12:00"},

{"IST", "+05:30"},

{"IT", "+03:30"},

{"JST", "+09:00"},

{"JT", "+07:00"},

{"MDT", "-06:00"},

{"MED", "+02:00"},

{"MET", "+01:00"},

{"MEST", "+02:00"},

{"MEWT", "+01:00"},

{"MST", "-07:00"},

{"MT", "+08:00"},

{"NDT", "-02:30"},

{"NFT", "-03:30"},

{"NT", "-11:00"},

{"NST", "+06:30"},

{"NZ", "+11:00"},

{"NZST", "+12:00"},

{"NZDT", "+13:00"},

{"NZT", "+12:00"},

{"PDT", "-07:00"},

{"PST", "-08:00"},

{"ROK", "+09:00"},

{"SAD", "+10:00"},

{"SAST", "+09:00"},

{"SAT", "+09:00"},

{"SDT", "+10:00"},

{"SST", "+02:00"},

{"SWT", "+01:00"},

{"USZ3", "+04:00"},

{"USZ4", "+05:00"},

{"USZ5", "+06:00"},

{"USZ6", "+07:00"},

{"UT", "-00:00"},

{"UTC", "-00:00"},

{"UZ10", "+11:00"},

{"WAT", "-01:00"},

{"WET", "-00:00"},

{"WST", "+08:00"},

{"YDT", "-08:00"},

{"YST", "-09:00"},

{"ZP4", "+04:00"},

{"ZP5", "+05:00"},

{"ZP6", "+06:00"}

};

Stefan Steiger answered 2020-07-24T18:25:41Z

-1 votes

这就是我要做的。

我从javascript接收了datetime，然后将其传递到ASP.NET以存储在Oracle数据库中。 这是我在东部和中部时间的C＃代码。

string datetimevalue = hidfileDateTime.Value;

datetimevalue= datetimevalue.Replace("EDT", "EST");

datetimevalue = datetimevalue.Replace("CDT", "CST");

if (datetimevalue.Contains("CST"))

{

filedt = DateTime.ParseExact(datetimevalue, "ddd MMM d HH:mm:ss CST yyyy", provider).ToUniversalTime().AddHours(1).ToLocalTime();

}

else

{

filedt = DateTime.ParseExact(datetimevalue, "ddd MMM d HH:mm:ss EST yyyy", provider);

}

Deep Kumar answered 2020-07-24T18:26:05Z