Re: [Dspace-tech] Meatadata dates stored as UTC

2010-07-01 Thread Mark H. Wood
It's just struck me that there ought to be established practice for dealing with date metadata for which the context of the object is the most significant in presenting them. If so, all we have to do is turn that into code. It would probably require that, alongside a date, we also record the time

Re: [Dspace-tech] Meatadata dates stored as UTC

2010-07-01 Thread TAYLOR Robin
> -Original Message- > From: Kim Shepherd [mailto:kim.sheph...@gmail.com] > Sent: 30 June 2010 22:07 > To: dspace-tech@lists.sourceforge.net > Cc: TAYLOR Robin; mw...@iupui.edu > Subject: Re: [Dspace-tech] Meatadata dates stored as UTC > > Robin wrote: > >

Re: [Dspace-tech] Meatadata dates stored as UTC

2010-06-30 Thread Kim Shepherd
Robin wrote: > I was looking at a series of photos of Mt St Helens prior to its eruption. It > struck me that the date and time recorded were part of a context. It was > crucial to know that it was 2.00pm on 29th June 1999 at Mt St Helens in the > US. If the date and time are converted to anothe

Re: [Dspace-tech] Meatadata dates stored as UTC

2010-06-30 Thread Mark H. Wood
The problem is that sometimes the most useful time zone is that of the context of the object, and sometimes it is that of the user. The software *cannot* know which is correct; only the user knows. Thus, no matter what zone we use, sometimes conversion will be wanted. So, either we always assume

Re: [Dspace-tech] Meatadata dates stored as UTC

2010-06-30 Thread TAYLOR Robin
Hi Kim, Thanks for the feedback, I'm pointlessly tying myself in knots about this. > I think storing in Zulu time makes sense, personally -- if > somebody in the USA takes a photograph, and records that date > in item metadata, I'd want it converted to Zulu so it could > be displayed to me in

Re: [Dspace-tech] Meatadata dates stored as UTC

2010-06-29 Thread Kim Shepherd
I think storing in Zulu time makes sense, personally -- if somebody in the USA takes a photograph, and records that date in item metadata, I'd want it converted to Zulu so it could be displayed to me in my local time zone (regardless of who was/wasn't in daylight savings time at the time of recordi

Re: [Dspace-tech] Meatadata dates stored as UTC

2010-06-28 Thread TAYLOR Robin
Hi Tom, > They're stored in Zulu time, which has the advantage of not > being dependent on time zones or daylight savings. But I guess my question is, why is that an advantage ? I can see some advantages eg searching and sorting, but I can also see cases where it would not be the right thing t

Re: [Dspace-tech] Meatadata dates stored as UTC

2010-06-25 Thread Tom De Mulder
On Fri, 25 Jun 2010, TAYLOR Robin wrote: > 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://ji