Virtuoso seems to use the servers timezone setting as default timezone and set the timezone for dates/datetimes without explicit timezone on import. E.g. DBpedia dates are all timezoned +02:00 (CEST), possibly because the server is located in the Netherlands (?)
DBpedia dates are actually not timezoned in the dumps: $ curl http://downloads.dbpedia.org/3.9/en/mappingbased_properties_en.ttl.bz2 | bzip2 -dc | grep releaseDate | head Virtuoso seems to use local timezone for them: [http://dbpedia.org/sparql?default-graph-uri=http%3A%2F%2Fdbpedia.org&query=SELECT+*%0D%0A%7B%3Fs+%3Chttp%3A%2F%2Fdbpedia.org%2Fontology%2FreleaseDate%3E+%3Fo%7D%0D%0ALIMIT+100] DBpedia Commons dates are timezoned +01:00 (CET), possibly because the server is located in Berlin and the import happened during winter (?): [http://commons.dbpedia.org/sparql?default-graph-uri=http%3A%2F%2Fcommons.dbpedia.org&query=SELECT+*+%7B%3Fs+%3Chttp%3A%2F%2Fpurl.org%2Fdc%2Fterms%2Fcreated%3E+%3Fo+.+%7D+LIMIT+100] My question is, how can I change this behavior and let Virtuoso return/import dates without any timezone? Or alternatively, how can I at least set the default time zone to UTC (Z)? Best, Magnus -- Magnus Knuth Hasso-Plattner-Institut für Softwaresystemtechnik GmbH Prof.-Dr.-Helmert-Str. 2-3 14482 Potsdam Amtsgericht Potsdam, HRB 12184 Geschäftsführung: Prof. Dr. Christoph Meinel tel: +49 331 5509 547 email: magnus.kn...@hpi.de web: http://www.hpi.de/ webID: http://magnus.13mm.de/ ------------------------------------------------------------------------------ One dashboard for servers and applications across Physical-Virtual-Cloud Widest out-of-the-box monitoring support with 50+ applications Performance metrics, stats and reports that give you Actionable Insights Deep dive visibility with transaction tracing using APM Insight. http://ad.doubleclick.net/ddm/clk/290420510;117567292;y _______________________________________________ Virtuoso-users mailing list Virtuoso-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/virtuoso-users
