• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 417
  • Last Modified:

Timestamp value

I'm bug fixing a website. It is too challenging, the coder played with server date and time to freeze the website for a particular duration everyday. I saw a table with timestamp field and the value is 1300202670. This field is compared with the server time in the code.

What is this value denote? Whether it is a date or time or something else?

Would like to know your thoughts on this.
Thanks.
0
CWS (haripriya)
Asked:
CWS (haripriya)
  • 2
  • 2
1 Solution
 
Rikin ShahMicrosoft Dynamics CRM ConsultantCommented:
can you share some more example values?
0
 
CWS (haripriya)Author Commented:
unfortunately only one value is there in the table.
0
 
Rikin ShahMicrosoft Dynamics CRM ConsultantCommented:
Can you share your code if possible to see what is exactly the logic.
0
 
wolfgang_93Commented:
I'm assuming you are referring to a table with a field called
"timestamp" which appears to have an integer value.

It appears that the developer collected Unix system date/time
values and saved them as integers in the table.

You can view the date/time for this field as follows:

select from_unixtime(timestamp) from table   <-- where "table" is the name of your table.
0
 
CWS (haripriya)Author Commented:
@wolfgang_93,

Your command does show the original date and time.
Thanks.
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now