Timezone Conversion from one to another

[Niju_Jose]

I have a collection called ProductPrice which contains ProductCode, ProductPrice,CreatedDateTime and CreatedTimeZone along with other fields. When user retrieve this data I want to display ProductCode, ProductPrice, CreatedDateTime, CreatedTimeZone, UTCconvertedDateTime.

Please help me convert the CreatedDateTime column into UTCDateTime using CreatedTimeZone column.

[Kushagra_Kesav]

Hey @Niju_Jose,

Welcome to the MongoDB Community forums

The ISODate in MongoDB is already in UTC. If I insert a new document in MongoDB Collection, it will get saved in UTC only.

{
  "_id": {
    "$oid": "64142cfe6abcfbb8b232d1a1"
  },
  "date": {
    "$date": "2023-03-17T09:03:37.567Z"
  }
}

To understand the question better, please provide further details, such as:

• The sample document from your MongoDB dataset.
• How the CreatedTimeZone and CreatedDateTime is being created in this context.
• The MongoDB Version you are using.
• The expected result documents.
• Any queries that you have tried to achieve the required results?

Best,
Kushagra