Solved

Timestamp value

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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Preface This is the third article about the EE Collaborative Login Project. A Better Website Login System (http://www.experts-exchange.com/A_2902.html) introduces the Login System and shows how to implement a login page. The EE Collaborative Logi…
Introduction Knockoutjs (Knockout) is a JavaScript framework (Model View ViewModel or MVVM framework).   The main ideology behind Knockout is to control from JavaScript how a page looks whilst creating an engaging user experience in the least …
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.
The viewer will the learn the benefit of plain text editors and code an HTML5 based template for use in further tutorials.

803 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