LinearHappy New Year! ... and one question (General)
I'm off to a good start and using my free time productively this year!
I am adding entries to a news page. It works great but I'd like to change the date field from the date I wrote it to an older date. Looking at content.sqlite I see the date field is int(11). How would I convert a date/time to the integer format?
Thanks!
Happy New Year! ... and one question
I finally got it by reading & trying examples on the web.
Using sqlitebrowser (http://sqlitebrowser.sourceforge.net) I changed the dates by opening content.sqlite and editing phpsqlitecms_pages.time record.
Using the linux date command:
date -d @1262321260
will output: Thursday, December 31, 2009, 23:47:40
To create a different date:
date --date="12/31/2009 23:47:40" +%s
will output: 1262321260
Hope this comes in handy for someone else too!
