Hi, I'm struggling with some dates issues and looking for help.
Dates held in the metadatavalues table are converted from their local time zone to UTC before being stored in the database. The problem is that they are not generally converted back to their local time zone before being displayed (see Jira http://jira.dspace.org/jira/browse/DS-568). This is misleading to the user. You could conceiveably see that you had submitted an item whilst you were still asleep in bed. I'm not sure what to do about this. It would be messy to always check for a metadatavalue being a date before displaying it. What would be the consequences of not storing dates as UTC ? Could we store them with a time zone eg "22:30+04" ? This might be a little less confusing. I'm sure there are good reasons for storing dates as UTC I just don't know what they are, can anyone help ? Cheers, Robin. Robin Taylor Main Library University of Edinburgh Tel. 0131 6513808 -- The University of Edinburgh is a charitable body, registered in Scotland, with registration number SC005336. ------------------------------------------------------------------------------ ThinkGeek and WIRED's GeekDad team up for the Ultimate GeekDad Father's Day Giveaway. ONE MASSIVE PRIZE to the lucky parental unit. See the prize list and enter to win: http://p.sf.net/sfu/thinkgeek-promo _______________________________________________ DSpace-tech mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/dspace-tech
