1

Topic: Time Stamp

If I look at a particular post in my database the time and date is recorded as (for example) 1105109247.

By how much per 24 hour period does this increase?

I need to know this for another feature on my site.

I've been down so long it's beginning to look like up..

Re: Time Stamp

its in seconds so 86400

Re: Time Stamp

JohnS wrote:

If I look at a particular post in my database the time and date is recorded as (for example) 1105109247.

That number is the number of seconds that have passed since 1970-01-01 00:00.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

4

Re: Time Stamp

Rickard wrote:

That number is the number of seconds that have passed since 1970-01-01 00:00.

That's what I needed. I want to be able to calculate a specific time on a date rather than just the date.

Thanks to both Rickard and Connorhd.

I've been down so long it's beginning to look like up..

5

Re: Time Stamp

How can i use it to group posts by month in mysql?
e.g.

  select count(*) from posts 
  group by --month of that date--
If your people come crazy, you will not need to your mind any more.

Re: Time Stamp

Is someone able to make me a little .php file that calculate the timestamp , like if I would put, the Year, date, hour, min, sec and time zone and returns me the timestamp... thank you

Re: Time Stamp

http://uk.php.net/manual/en/function.mktime.php

Re: Time Stamp

http://e26.co.uk/stuff/unix