Hey. We are using from_unixtime() function which accepts seconds. from_unixtime() is used to convert the Unix timestamp to a String representing Date and Timestamp, in other words, it converts the Epoch time in seconds to date and timestamp. Having said that... In our example the time is in milliseconds and that's why we divided the same by 1000.
crystal clear sir 👌
Thanks a lot for your feedback 🙂
Thanks for the information. Clear and simple.
Thanks a lot Sir.
Sir if u want both year and month in one column then how can we write that command can u plzzz help me...
Could you explain Why did you divided by 1000 to covert it to seconds.
Hey. We are using from_unixtime() function which accepts seconds.
from_unixtime() is used to convert the Unix timestamp to a String representing Date and Timestamp, in other words, it converts the Epoch time in seconds to date and timestamp.
Having said that... In our example the time is in milliseconds and that's why we divided the same by 1000.