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
3
votes
1 answer

ffmpeg input image list with timestamp in filename

How can I convert a list of input .png images which contain an ISO time stamp in their filename? ffmpeg -y -f image2 -pattern_type glob -i '*.png' output.mp4 do not manage colons : in a ISO-format filename such as 2018-01-29T06:43:21.png, and other…
leonard vertighel
  • 1,058
  • 1
  • 18
  • 37
3
votes
1 answer

How to compare 2 ISODate fields in Mongo?

I have 2 fields like this in my document "DATE_1" : ISODate("2017-08-11T04:00:00Z") "DATE_2" : ISODate("2017-06-12T04:00:00Z") I would like to select documents with "DATE_1" is greater than "DATE_2" and i tried the following query which should…
user3528213
  • 1,415
  • 3
  • 15
  • 18
3
votes
3 answers

MongoDB ISODate field search using Java

I am having trouble searching ISODate field in mongodb using Java. I want to find exact matched date. Here's how I query first collection and get ISODate field "Timestamp". Once I get this date, I want to search another collection with the same…
ejshin1
  • 1,107
  • 6
  • 17
  • 35
3
votes
3 answers

Change String date to ISO date in MongoDB?

In MongoDB, I have a document with a field called "date" and that is in array. { "_id" : ObjectId("587627a2125a730f78a20859"), "data" : [ { "Number" : "359983007479839", "date" : "2016-02-10T21:56:33.000Z" } ] after that…
TB.M
  • 363
  • 3
  • 8
  • 26
3
votes
1 answer

Does Mongodb queries a record by DateTime quicker than by String?

For example, this is a record: { "_id" : ObjectId("576bc7a48114a14b47920d60"), "id" : "TEST0001", "testTime" : ISODate("2016-06-23T11:28:06.529+0000") } The testTime is ISODate, does Mongodb query the record by testTime is…
adairjun
  • 325
  • 4
  • 16
3
votes
6 answers

How to produce a formatted date string in Q/KDB?

How can one produce an ISO date string "yyyy-MM-dd" from a Q date type? I looked at concatenating the various parts but am not even able to get the day/month, e.g. d:2015.12.01;d.month prints 2015.12, i.e. more than just the month.
ScarletPumpernickel
  • 678
  • 1
  • 7
  • 22
3
votes
1 answer

How to create negative datetime in python 2.7

I need to insert into mongo db some BC dates but I cant create datetime with negative value like datetime.datetime(-2000, 2, 1), but in mongodb it is possible to do with IsoDate, so how can i create negative dates in python? I'm currently using…
GALIAF95
  • 619
  • 1
  • 10
  • 25
3
votes
0 answers

Query MongoDB ISO date between two dates in Perl

I am working with MongoDB and am not having an easy time trying to add the less-than to my working $gte query. The below query works when I remove the $lt line from it. I am trying to get records between two dynamic dates - minutes. That does work…
Steve Lichtman
  • 29
  • 2
3
votes
2 answers

joda time ISO DateTime formatting

I'm using joda time to format my ISO Date input string, but I'm getting an exception that my ISO Date is malformed: Invalid format: "2014-06-20T11:41:08+02:00" is malformed at "+02:00" This is my code: val formatter: DateTimeFormatter =…
pichsenmeister
  • 2,132
  • 4
  • 18
  • 34
3
votes
1 answer

mongodb ISODate problems

I am using java(IDE is eclipse) to query on mongodb. Below is my java code: DBObject query = new BasicDBObject(); ObjectId id =new ObjectId("529f280b90ee58cb7732c2b8"); query.put("_id", id); DBCursor cursor =…
wuchang
  • 3,003
  • 8
  • 42
  • 66
3
votes
1 answer

MongoDB aggregate by date in string format doesn't work

I have a mongodb collection with a date field "localHitDate" which is a string property and I'd like to aggregate on this date. So, I have to convert my date string into a BSON date type, but it did not work : db.log.aggregate([ {…
Fred Mériot
  • 4,157
  • 9
  • 33
  • 50
3
votes
2 answers

Java Date format issue?

I have a String date: 2013-05-23T00:00:00+00:00 And I want to format it using the ISODateTimeFormat class: DateTimeFormatter myParser = ISODateTimeFormat.dateTimeNoMillis(); myDate = myParser.parseDateTime(myDateAsString).toDate(); The formatted…
user86834
  • 5,357
  • 10
  • 34
  • 47
3
votes
2 answers

How can I store date prior to B.C in MongoDB as ISODate?

In MongoDB I've stored dates prior to B.C has String type. How can I stored in ISODate() type ? I've tried this : db.test.insert({"date" : new ISODate("-63-09-23") }) but I get an error : uncaught exception: invalid ISO date Thanks for your help !
FabSommavilla
  • 157
  • 1
  • 3
  • 15
2
votes
1 answer

Is there a way to use filterByFormula in Airtable to filter by a specific field value by date without it defaulting to the first entry in the table?

I am trying to filter by date to get one specific record, of which the Name field should = 8/01/2022. (I used the Name field in Airtable to place the dates. I set the field type to date.) The issue I'm having is that although it seems to work fine,…
afunnyworld
  • 78
  • 9
2
votes
2 answers

Why does datetime.now().isoformat() return an invalid isoformat string according to time.fromisoformat()?

Running Python 3.8.10, came across this today: from datetime import datetime, time time.fromisoformat(datetime.now().isoformat()) Results in: Traceback (most recent call last): ValueError: Invalid isoformat string:…
Wes Williams
  • 69
  • 1
  • 7
1 2
3
…
15 16