Got no real insight here Ian. The one using a Data object does it assign a
timezone? Or is assuming your current locale. I would update the test to
create the Date with a known timezone before expecting consistent results.
--
Jody
--
Jody Garnett
On 14 January 2015 at 08:32, Ian Turton <ijtur...@gmail.com> wrote:
> While messing with SQLServer I've hit an issue with one of the date tests
> failing. It passes on master even though the same issue is present in the
> convertor. So I'm unsure as to what I'm doing wrong - if you consider this
> test (that could be added to TemporalConvertorFactoryTest in main
> org.geotools.utils )
>
> public void testDatetoDate() throws Exception {
> Date date = new SimpleDateFormat("yyyy-dd-MM").parse("2009-28-06");
> assertNotNull(factory.createConverter(Date.class, java.sql.Date.class,
> null));
>
> java.sql.Date output = (java.sql.Date)
> factory.createConverter(Date.class, java.sql.Date.class,
> null).convert(date, java.sql.Date.class);
>
> assertEquals("2009-06-28", output);
> }
>
> It fails as the convertor reduces the time to GMT which forces it in the
> previous day (if you are in the UK anyway) so the answer comes back as
> 2009-06-27. I can't decide if this is correct or not and the comments don't
> offer any help.
>
> But in the JDBCDateTests testFilterByDate - runs two queries one with
> 2009-06-29 as a string and once as a date object. The first correctly
> returns 2 rows and the second fails as it only returns 1 bacause the day
> has changed.
>
> But I can't see any changes I've made between my sqlserver-jtds branch and
> master that would cause this to work before. So if anyone can throw some
> light on this I'd be very grateful.
>
> Cheers
>
> Ian
>
>
> ------------------------------------------------------------------------------
> New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
> GigeNET is offering a free month of service with a new server in Ashburn.
> Choose from 2 high performing configs, both with 100TB of bandwidth.
> Higher redundancy.Lower latency.Increased capacity.Completely compliant.
> http://p.sf.net/sfu/gigenet
> _______________________________________________
> GeoTools-Devel mailing list
> GeoTools-Devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geotools-devel
>
>
------------------------------------------------------------------------------
New Year. New Location. New Benefits. New Data Center in Ashburn, VA.
GigeNET is offering a free month of service with a new server in Ashburn.
Choose from 2 high performing configs, both with 100TB of bandwidth.
Higher redundancy.Lower latency.Increased capacity.Completely compliant.
http://p.sf.net/sfu/gigenet
_______________________________________________
GeoTools-Devel mailing list
GeoTools-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel
