photo

Propman

shared this question
5 years ago

Employees Involved

photo

PIV Support

Admin

Statistics

2
Comments
176
Views

Relates to

Share

Tags

1
votes

Date modified value in database

How is the database value under pages called pagesmain_date calculated?

Because of PHP used in forms, it's a lot easier for me to edit via phpmyadmin.

However this of course doesn't update the page date used for the XML sitemap.

This value gives me 1405415373 - 15/07/2014 09:09 PM

I don't quite get how the two relate.

Even if I edit the page in the OR admin editor, it doesn't seem to increment the pagesmain_date value.

Please advise. Thank you~

Add Comment

Comments (2)

photo Employee
1

OR stores dates (timestamps) as most apps do, using UNIX timetamps.

1405415373 = 07/27/2014 @ 11:36pm UTC

http://en.wikipedia.org/wiki/Unix_time

http://www.unixtimestamp.com/index.php

photo
1

Sorry my mistake..

Thank you very much.

Leave Comment

photo

Attach files...

The file must be a jpg, gif, png, bmp, ico, pdf, doc, rtf, txt, zip or rar no more than 20M