Stack Overflow
Stack Overflow

Questions tagged [isodate]

Anything related to ISO standard date formats, i.e. a series of ISO-standardized formats for date and time information meant to be "understandable" worldwide, like the following string "2013-10-02 15:35:02".

Anything related to ISO standard date formats, i.e. a series of ISO-standardized formats for date and time information meant to be "understandable" worldwide.

For example, the following string "2013-10-02 15:35:02" represents the following time in ISO format: 

   year: 2013
  month: 10
    day: 2
   hour: 15 
minutes: 35
seconds: 2
240 questions
2
votes
1 answer

JS moment parse date format

I have a timestamp with this format 09:53:56,07-04-2021 How do I convert it to ISO format ? I have tried moment("09:53:56,07-04-2021").format("hh:mm:ss,mm-dd-yyyy") I'm getting "Invalid date" message
Mohammad Shehab
  • 35
  • 5
2
votes
2 answers

BigQuery: Format ISO Date

I'm trying to parse a timestamp which is in ISO Date 8601 format. Example: 2021-04-10T14:11:00Z This information is stored inside a JSON object and for that reason I'm extracting that data as a string: The format I'm looking for is a yy-MM-dd hh:mm…
Luis Alberto Delgado de la Flo
  • 1,914
  • 4
  • 16
  • 43
2
votes
1 answer

Searching for MongoDB ISODate Using Spring Data @Aggregation

I have a Spring API connecting to a MongoDB database. I am trying to use Spring's @Aggregation to find entries in a "Shipment" document which have a "shipDate" later than the date specified by the user. Here is an example of my repository: import…
Kylep5587
  • 87
  • 6
2
votes
1 answer

How to update date string in array to date format in mongoDB?

My mongoDB collection looks like this: [ { "id": "myid", "field": { "total": 1, "subfield": [ { "time": "2020-08-06T08:33:57.977+0530" }, { "time":…
Tiya Jose
  • 1,359
  • 14
  • 24
2
votes
0 answers

Charts.js + Django date on X-Axis

I do fear that similar questions have been asked in the past, however I was not able to derive a solution for my specific issue. I am sending data from a Django function to Charts.js The chart gets rendered correctly and displays with the exception…
S. Pynewb22
  • 113
  • 3
  • 10
2
votes
5 answers

How to get unique date values from object array

I need to get all unique days of multiple date values in the format DD.MM.. In this example data, there are two values for the 24th of december: const data = [ { date: ISODate("2019-12-24T03:24:00Z") }, { date:…
user3142695
  • 15,844
  • 47
  • 176
  • 332
2
votes
1 answer

Why does mongodb change my date formats to long number and how do I fix it?

I have been storing some dummy data on a project I've been working on. Some data include dates in the format of date. But somehow, I saw it changed the format to long number and I have no idea why. Can someone please tell me how to convert the…
nam
  • 116
  • 1
  • 10
2
votes
1 answer

Difference between yyyy-MM-dd'T'HH:mm:ss.SSSZZ and yyyy-MM-dd'T'HH:mm:ss.SSSXXX?

Wondering if they represent different formats or are essentially the same (just new vs old presentations).
user1589188
  • 5,316
  • 17
  • 67
  • 130
2
votes
1 answer

MongoDB can not find documents that has two different fields which are including equal date

I was using Postgresql for my project, but lately I faced some performance problems and decided to try MongoDB. But this time I'm in the another sea of problems and I'm sinking. The most important fields of my Table/Collection are "StartDate" and…
Cem
  • 48
  • 5
2
votes
1 answer

Difference between "now" and a given date

I need to retrieve all documents in a collection that the difference between new ISODate() and a date field of the document should be greater than a given parameter. I can do this on mongo shell by the…
Tiago Donizete dos Santos
  • 35
  • 5
2
votes
1 answer

ISO 8601 Date Portion ONLY

Our front end wants only a date. My understanding is that the industry standard for JSON.NET and Web Api is ISO 8601. Is is possible to return a date portion ONLY from our Web Api while adhering to ISO 8601 standards, or will the date property…
birdus
  • 7,062
  • 17
  • 59
  • 89
2
votes
2 answers

How do I insert an ISODate into mongoDB via Postman?

How do I insert an ISODate into MongoDB via Postman? I have looked around but examples/queries on this subject tend to be just for ways of getting various string formats. I have an in-house API set up on my localhost so I am querying the database…
jesus g_force Harris
  • 485
  • 6
  • 16
2
votes
0 answers

Mongodb aggregation comparing ISO dates returns no documents

My $lte (body.to) date: 2019-04-24T15:42:16.472Z My $gte (body.from) date: 2019-03-25T15:42:16.472Z My aggregation match stage: { $match: { 'workflow.site.completedAt': { $exists: true // $lte: body.from …
SebastianG
  • 8,563
  • 8
  • 47
  • 111
2
votes
1 answer

How do you group by isodate year, month, day?

How to group by isodate, preferably by year, month, day?
charlie rose
  • 21
  • 3
2
votes
1 answer

compare date in mongodb

so i have this document in my collection db.person.insertOne( { name: "vincent", age: 40, alarm: {morning:new Date("2018-11-14T10:00:00Z") , night: new Date("2018-11-14T23:00:00Z")}}) and i need to check if there is an alarm (morning alarm or…
Az Emna
  • 527
  • 2
  • 10
  • 26
1 2 3
…
15 16