blog documentation FAQ followers forum marketplace services youtube

Datetime format in database

The Jamroom Network » Forum » Installation and Configuration » Page » Datetime format in database
sekeri
sekeri
@ilker
11 years ago
334 posts
I am trying to upload my existing articles to Jamroom. I need to modify created date for each article to the actual date it was published. I plan to do it using phpmyadmin. But dates are saved in a special format in Jamroom and I dont know how to convert dates to this special char format. (ex: 1397454711 ) For example , how can I convert 25.11.2013 to this format to update the value in database?

updated by @ilker: 05/15/14 03:31:27AM
paul
@paul
11 years ago
4,335 posts
Jamroom dates are saved in 'unixtime'. This is a count of the number of seconds elapsed since 1st January 1970.
If you Google something like 'unixtime converter', there are sites where you can convert online.

However, might it be better if you created a custom date field for your article form with the Form Designer? You could then enter the date conventionally and let JR convert it for you?


--
Paul Asher - JR Developer and System Import Specialist
sekeri
sekeri
@ilker
11 years ago
334 posts
'unixtime'.. perfect! I also will consider the second option you offer. Thank you Paul.

Tags