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.
LVL 16
CWS (haripriya)Asked:
Who is Participating?
 
wolfgang_93Connect With a Mentor Commented:
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
 
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
 
CWS (haripriya)Author Commented:
@wolfgang_93,

Your command does show the original date and time.
Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.