Hello Clive & Stuart, I got the same output that Clive is getting, but when I change the issued date of the item, by editing it, and remove the time zone, full date is shown in issued date column.
Thanks. On Sat, Aug 7, 2010 at 2:25 PM, Clive Gould <[email protected]> wrote: > Hi Stuart :) > > I've already run the index-init script several times. > > Here is an item in our restored 1.5.2 production server: > > http://vle.bromley.ac.uk/dspace/handle/2045/22 > > and here is the same item in our 1.6.2 test server: > > http://standbyvle.bromley.ac.uk/dspace/handle/2045/22 > > You can clearly see the difference in the issue date display format. > > Do you know "off hand" the postgres commands l need to use to view the > tables or is it better I reinstall phpPgAdmin? > > Thanks very much > > Clive > > > > > > On Sat, Aug 7, 2010 at 9:32 AM, Stuart Lewis <[email protected]> > wrote: > > Hi Clive / Rajshekhar, > > > >> I notice that with DSpace 1.5.2 on our server the strange codes were > >> already there before the database upgrade: > >> > >> dc date accessioned 2009-04-29T05:57:26Z > >> dc date available 2009-04-29T05:57:26Z > >> dc date issued 2009-04-29T05:57:26Z > > > > These dates are completely normal. See: > http://en.wikipedia.org/wiki/ISO_8601#UTC > > > > Basically it is a way of describing date / time fields in a timezone > neutral way. > > > > year-month-day T (to denote the start of the Time part) > hour:minute:second Z (zulu time) > > > > Therefore the contents of your database appear to be fine. When you view > an item, are the dates correct in there - is it just the browse screens that > appear wrong? > > > > Since upgrading, have you re-indexed your browse tables? Step 10 of the > upgrade instructions ( > http://www.dspace.org/1_6_2Documentation/ch04.html#N10FE6) says to run: > > > > - [dspace]/bin/dspace index-init > > > > You could look in your browse index tables bi_* and see what values they > are holding. Are they holding the expected dates in the format you would > expect? > > > > Thanks, > > > > > > Stuart Lewis > > IT Innovations Analyst and Developer > > Te Tumu Herenga The University of Auckland Library > > Auckland Mail Centre, Private Bag 92019, Auckland 1142, New Zealand > > Ph: +64 (0)9 373 7599 x81928 > > > > > -- Regards, Rajshekhar Pandey Software Programmer Webinito Networks.
------------------------------------------------------------------------------ This SF.net email is sponsored by Make an app they can't live without Enter the BlackBerry Developer Challenge http://p.sf.net/sfu/RIM-dev2dev
_______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
