[COMPASS-3021] Convertion from String to ISODate values are getting changed for date Created: 27/Jul/18  Updated: 27/Oct/23  Resolved: 14/Nov/18

Status: Closed
Project: Compass
Component/s: Compass
Affects Version/s: 1.14.6
Fix Version/s: None

Type: Bug Priority: Critical - P2
Reporter: Mukesh Sharma Assignee: Unassigned
Resolution: Works as Designed Votes: 0
Labels: None
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Linux


Attachments: PNG File image-2018-07-27-10-20-51-866.png    

 Description   

db version v4.0.0
I used above version to test our analytics project and in Mongo db have multiple issues.

  1. Date values from String to ISODate datatype changes converting different values example. Date : 1995-01-01 after changing in ISODate thru Mongo shell command or Compass UI its coming 1994-12-31 16:00:00.000
  2. Other issue is Time base column have 12:00:00 this data and in String data type and if I convert timestamp then its coming only 0 (zero).

Please see attached screen shot for above issues.

I am in IBM analytics and certifying this database and having these issue. Help me out.



 Comments   
Comment by Massimiliano Marcon [ 14/Nov/18 ]

Hi mukesh_srma@yahoo.com.

The first problem you described is no longer there in Compass 1.16.

The second problem isn't really a bug: the string "12:00:00" can't be converted to a date, nor can it be converted to a Timestamp value. What would you expect to see it converted to? What timestamp?

I am going to close this ticket, but please let me know if you still see a problem.

Generated at Wed Feb 07 22:31:52 UTC 2024 using Jira 9.7.1#970001-sha1:2222b88b221c4928ef0de3161136cc90c8356a66.