What Does This Format Means T00:00:00.000Z

What does this format means T00:00:00.000Z?

It's a part of ISO-8601 date representation. It's incomplete because a complete date representation in this pattern should also contains the date:

2015-03-04T00:00:00.000Z //Complete ISO-8601 date

If you try to parse this date as it is you will receive an Invalid Date error:

new Date('T00:00:00.000Z'); // Invalid Date

So, I guess the way to parse a timestamp in this format is to concat with any date

new Date('2015-03-04T00:00:00.000Z'); // Valid Date

Then you can extract only the part you want (timestamp part)

var d = new Date('2015-03-04T00:00:00.000Z');
console.log(d.getUTCHours()); // Hours

What does the ".000Z" of "yyyy-mm-ddT00:00:00.000Z" mean?

.000 is the fraction of a second and Z indicates UTC timezone.

How you convert to your local time will depend on which programming language you prefer, but for example Perl has standard modules for parsing and formatting times.

Android convert T00:00:00.000Z date to simple readable date format

try this:

 String  createdAt = new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss.SSSZ").format(df.toCalendar(channel.getString("createdAt")).getTimeInMillis());

here is an example:

String string = "2016-12-02T00:00:00.000Z";
String defaultTimezone = TimeZone.getDefault().getID();
Date date = (new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss.SSSZ")).parse(string.replaceAll("Z$", "+0000"));

Log.i("string: " + string);
Log.i("defaultTimezone: " + defaultTimezone);
Log.i("date: " + (new SimpleDateFormat("yyyy-MM-dd'T'HH:mm:ss.SSSZ")).format(date));

Why formatting date in angular formatted or moment formatted reduce on day from date with time T00:00:00.000Z

The ugly solution, assuming those date values from db are actual strings and not date objects, and if I understand correctly you only care about the day, you can slice the string like this:

moment(date.slice(0, -14)).format('YYYY-MM-DD')

How to get date in following format "2017-06-06T07:00:00.000Z" in Python?

Yes, it is ISO format (see ISO 8601) and you can produce it in Python in several ways, in particular using time.strftime("%Y-%m-%dT%H:%M:%SZ", time.gmtime()).

How to convert "1985-02-07T00:00:00.000Z" (ISO8601) to a date value in Oracle?

to_date converts the input to a DATE type which does not support fractional seconds. To use fractional seconds you need to use a TIMESTAMP type which is created when using to_timestamp

pst's comment about the ff3 modifier is also correct.

"Constant" values in the format mask need to be enclosed in double quote

So the final statement is:

select to_timestamp('1985-02-07T00:00:00.000Z', 'YYYY-MM-DD"T"HH24:MI:SS.ff3"Z"')
from dual;

How to convert a datestring to date object without timezone

You're overcomplicating

function convertToDateFormat(Datestr) {
if ( Datestr!="" ) { // Datestr="03/08/2016"
var datedata = Datestr.split("/");
var formatedDateString=datedata[2]+'-' + datedata[1] + '-' + datedata[0] + 'T00:00:00.000Z';
return formatedDateString;
console.log(convertToDateFormat("03/08/2016")) // 2016-08-03T00:00:00.000Z

Related Topics

Leave a reply