---
title: Timestamp Difference in UI and DB
description: "Hi Team, CK Birla raised an issue where for some leads Lead Categorisation - BFI activity time stamp shows time different to what in DB. Sample lead - ..."
url: "https://supportb.kinsta.cloud/docs/timestamp-difference-in-ui-and-db/"
updated: "2023-10-19"
category: General
---

# Timestamp Difference in UI and DB

Hi Team,

CK Birla raised an issue where for some leads Lead Categorisation - BFI activity time stamp shows time different to what in DB.

Sample lead - [https://in21.leadsquared.com/LeadManagement/LeadDetails?LeadID=8bd166d3-2938-44f0-af18-0c58ed80fdc6&pageNumber=1](https://in21.leadsquared.com/LeadManagement/LeadDetails?LeadID=8bd166d3-2938-44f0-af18-0c58ed80fdc6&pageNumber=1)

The activity was added Manually and not via API.

PFB:
![](https://desk.zoho.in/support/ImageDisplay?downloadType=uploadedFile&fileName=1697199042784.png&blockId=edbsn7a254ab041d048b562be2a05a6d72c506fbdb1cc0cc13887fc1024951fb03a97&zgId=edbsnb94eea216c2b0d7d218bf29c6a0d6f91&mode=view)

Time stamp shows: 01st Oct 1:34 AM

However in Clone DB (They have access to it) it shows 30-09-2023 20:04, difference around 5.30hrs.

Analysis: Post checking with Dev could confirm that it is an expected behavior. We save the activity date time in DB in UTC format and UI it converts into
user time-zone and display it.

From the above screen shot, the user would have created the activity on UI on 1st Oct 1:34 AM. but in DB it stored in UTC i.e. 30th sept 20:04 
I hope this helps.

Best,
Kiran