1

I'm looking for the "start publishing" field into the xx_content of my database. I Don't see any column named like that. I can't find where its value are store.

Any idea where I could find it? (Joomla! 3.3.1)

Improve this question

1 Answer 1

Reset to default
4

In the #__content database table, the column you're looking for is publish_up. This contains the timestamp value for the publish date.

See screenshot below:

enter image description here

Improve this answer
8
  • But for each article the "start publishing" values saved in frontend (or backend) doesn't correspond to the "publish_up" value... I checked for several articles.
    – JinSnow
    Commented Aug 19, 2014 at 14:34
  • Which timezone are you? I will try to replicate what you have
    – Lodder
    Commented Aug 19, 2014 at 14:35
  • thanks looder! Universal time coordinated (the dates look like that: 2011-10-15 00:00:00)
    – JinSnow
    Commented Aug 19, 2014 at 14:41
  • 1
    Have a look at the query you used to import the articles from Joomla 1.5 and see how the publish date it processed
    – Lodder
    Commented Aug 19, 2014 at 15:06
  • 1
    Joomla 3 will store the datetimes always in UTC timezone. If the user has a different timezone, it will calculate the difference and show the timezone adjusted datetime. This may be something that confuses.
    – Bakual
    Commented Aug 19, 2014 at 19:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.