Solved

Timestamp value

Posted on 2011-03-25
5
406 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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

Suggested Solutions

Preface This article introduces an authentication and authorization system for a website.  It is understood by the author and the project contributors that there is no such thing as a "one size fits all" system.  That being said, there is a certa…
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…
Viewers will learn about basic arrays, how to declare them, and how to use them. Introduction and definition: Declare an array and cover the syntax of declaring them: Initialize every index in the created array: Example/Features of a basic arr…
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

760 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now