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)

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

  • 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 Aug 19 '14 at 14:34
  • Which timezone are you? I will try to replicate what you have – Lodder Aug 19 '14 at 14:35
  • thanks looder! Universal time coordinated (the dates look like that: 2011-10-15 00:00:00) – JinSnow Aug 19 '14 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 Aug 19 '14 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 Aug 19 '14 at 19:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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