I have this value in timestamp field 1635527918.1891065. How I convert it in format yyyy/mm/dd?

timestamp: 1635527918.1891065

Welcome to the community :slight_smile:

This is a forum for chatbot-building with Rasa. General programming questions like yours are better asked on StackOverflow.

Your question does not have enough info for us to be able to help anyway.

  • Which programming language are you using?
  • How are you getting that timestamp?
  • What have you tried?

Please read “How to ask a great question”, this applies for all coding forums.

Thanks for the info. Just to complete the question, I am trying to query a postpress database for the dates on which the conversations took place. The values ​​are of dates, they are integers and they are in the format in which I asked the question.

If you are using python:

https://www.programiz.com/python-programming/datetime/timestamp-datetime

hope this will help you. import datetime

getting local time

local_time = datetime.datetime.fromtimestamp(1635527918.1891065).strftime(‘%Y-%m-%d %H:%M:%S’) print(local_time)

get utc time

utc_time = datetime.datetime.utcfromtimestamp(1635527918.1891065).strftime(‘%Y-%m-%d %H:%M:%S’) print(utc_time)