date format yyyy-MM-ddTHH mm ssZ

Question

I assume this should be pretty simple  but could not get it     In this format Z is time zone   T is long time pattern  How could I get a date in this format except by using   DateTime dt   DateTime Now  Console WriteLine dt ToString  yyyy-MM-ddTHH mm ssZ       in C

User · Answer

It works fine with Salesforce REST API query datetime formats

DateTime now = DateTime.UtcNow;
string startDate = now.AddDays(-5).ToString("yyyy-MM-ddTHH\\:mm\\:ssZ");   
string endDate = now.ToString("yyyy-MM-ddTHH\\:mm\\:ssZ");  
//REST service Query 
string salesforceUrl= https://csxx.salesforce.com//services/data/v33.0/sobjects/Account/updated/?start=" + startDate + "&end=" + endDate;

// https://csxx.salesforce.com/services/data/v33.0/sobjects/Account/updated/?start=2015-03-10T15:15:57Z&end=2015-03-15T15:15:57Z

It returns the results from Salesforce without any issues.

User · Answer

In C  6  you can use string interpolation and make this more terse      DateTime UtcNow s Z

User · Answer

o  format is different for DateTime vs DateTimeOffset     DateTime UtcNow ToString  o   - gt   2016-03-09T03 30 25 1263499Z   DateTimeOffset UtcNow ToString  o   - gt   2016-03-09T03 30 46 7775027 00 00    My final answer is   DateTimeOffset UtcDateTime ToString  o       for DateTimeOffset type DateTime UtcNow ToString  o                  for DateTime type

User · Answer

One option could be converting DateTime to ToUniversalTime   before converting to string using  o  format   For example   var dt   DateTime Now ToUniversalTime    Console WriteLine dt ToString  o       It will output   2016-01-31T20 16 01 9092348Z

User · Answer

Using UTC  ISO 8601  MSDN datetime formats   Console WriteLine DateTime UtcNow ToString  s      Z         2009-11-13T10 39 35Z   The Z is there because     If the time is in UTC  add a  Z    directly after the time without a   space   Z  is the zone designator for   the zero UTC offset   09 30 UTC  is   therefore represented as  09 30Z  or    0930Z    14 45 15 UTC  would be    14 45 15Z  or  144515Z     If you want to include an offset  int hours   TimeZoneInfo Local BaseUtcOffset Hours  string offset   string Format   0  1     hours  gt 0            hours ToString  00     string isoformat   DateTime Now ToString  s     offset  Console WriteLine isoformat     Two things to note    or - is needed after the time but obviously   doesn t show on positive numbers  According to wikipedia the offset can be in  hh format or  hh mm  I ve kept to just hours   As far as I know  RFC1123  HTTP date  the  u  formatter  isn t meant to give time zone offsets  All times are intended to be GMT UTC

User · Answer

Single Line code for this   var temp      DateTime UtcNow ToString  yyyy-MM-ddTHH   mm   ssZ

User · Answer

Look here at  u  and  s  patterns  First is without  T  separator  and the second one is without timezone suffix

User · Answer

You could split things up  it would require more code but would work just the way you like it   DateTime year   DateTime Now Year  DateTime month   DateTime Now Month  DateTime day   DateTime Now Day    ect   finally   Console WriteLine year month day etc      This is a very bold way of handling it though

User · Answer

Console WriteLine DateTime UtcNow ToString  o       Console WriteLine DateTime Now ToString  o       Outputs     2012-07-09T19 22 09 1440844Z   2012-07-09T12 22 09 1440844-07 00

[c#] date format yyyy-MM-ddTHH:mm:ssZ

Examples related to c#