OJS OCS OMP OHS

You are viewing the PKP Support Forum | PKP Home Wiki



Dates vs Timestamp

Are you an Editor, Author, or Journal Manager in need of help? Want to talk to us about workflow issues? This is your forum.

Moderators: jmacgreg, michael, vgabler, John

Forum rules
This forum is meant for general questions about the usability of OJS from an everyday user's perspective: journal managers, authors, and editors are welcome to post questions here, as are librarians and other support staff. We welcome general questions about the role of OJS and how the workflow works, as well as specific function- or user-related questions.

What to do if you have general, workflow or usability questions about OJS:

1. Read the documentation. We've written documentation to cover from OJS basics to system administration and code development, and we encourage you to read it.

2. take a look at the tutorials. We will continue to add tutorials covering OJS basics as time goes on.

3. Post a question. Questions are always welcome here, but if it's a technical question you should probably post to the OJS Technical Support subforum; if you have a development question, try the OJS Development subforum.

Dates vs Timestamp

Postby ramon » Wed Aug 25, 2004 12:43 pm

Kevin,

How does vrs 2.0 address the date issue?

If you plan to use the strftime() and setlocale functions, there may be a problem when trying to integrate information from various journals, as well as for the PKP Repository, or any other for that matter. I´m not sure if the setlocale() would change the server date, as it is inserted as YYYY/mm/dd - hour.... today.

I´m no expert, but I think that using a timestamp, which means converting the date into a number to save in the database, will be the best choice. There would be a need to process each date for display issues, but it would be safer.

However, I´m not sure if there may be problems using different date formats and values in the database.

What do you think??

thkns
ramon
 
Posts: 929
Joined: Wed Oct 15, 2003 6:15 am
Location: Brasí­lia/DF - Brasil

Postby kevin » Wed Aug 25, 2004 7:51 pm

What is the "date issue" you are referring to?

I don't see how the internal representation of a date (integer timestamp vs. an ISO formatted string) stored in the database makes a difference.
kevin
 
Posts: 338
Joined: Tue Oct 14, 2003 8:23 pm

Date issue

Postby ramon » Thu Aug 26, 2004 6:17 am

Kevin,

Since I´m no expert on the subject I assumed there may be a problem with statistics, migration, review assignment and harvesting.

But, if you say there is no problem, then it´s all good :D

Updating our database, for example, to alter date display and db input would be a major task, wouldn´t it?

Would it be helpful to try to implement the strftime() and setlocale() in 1.1.8?

Thnks
ramon
 
Posts: 929
Joined: Wed Oct 15, 2003 6:15 am
Location: Brasí­lia/DF - Brasil

Postby kevin » Thu Aug 26, 2004 8:29 am

Simply changing how dates are displayed to users is not a major change.
kevin
 
Posts: 338
Joined: Tue Oct 14, 2003 8:23 pm


Return to OJS Editorial Support and Discussion

Who is online

Users browsing this forum: Google [Bot], sumpcre and 1 guest