Solved

Timestamp value

Posted on 2011-03-25
5
410 Views
Last Modified: 2012-05-11
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
Comment
Question by:CWS (haripriya)
  • 2
  • 2
5 Comments
 
LVL 19

Expert Comment

by:Rikin Shah
ID: 35213643
can you share some more example values?
0
 
LVL 16

Author Comment

by:CWS (haripriya)
ID: 35213879
unfortunately only one value is there in the table.
0
 
LVL 19

Expert Comment

by:Rikin Shah
ID: 35213896
Can you share your code if possible to see what is exactly the logic.
0
 
LVL 8

Accepted Solution

by:
wolfgang_93 earned 500 total points
ID: 35235424
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
 
LVL 16

Author Comment

by:CWS (haripriya)
ID: 35240023
@wolfgang_93,

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

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Preface In the first article: A Better Website Login System (http://www.experts-exchange.com/A_2902.html) I introduced the EE Collaborative Login System and its intended purpose. In this article I will discuss some of the design consideratio…
Styling your websites can become very complex. Here I'll show how SASS can help you better organize, maintain and reuse your CSS code.
The viewer will learn how to count occurrences of each item in an array.
The viewer will learn the basics of jQuery including how to code hide show and toggles. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question