<div dir="ltr">sorry.. I'm way out-of-date there (or is it out-of-timestamp). Can't see an elegant fix either.</div><div class="gmail_extra"><br><div class="gmail_quote">On 1 February 2017 at 17:47, James Gilbert <span dir="ltr"><<a href="mailto:jgrg@sanger.ac.uk" target="_blank">jgrg@sanger.ac.uk</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word"><div>Really? Comparisons of oracle DATE and TIMESTAMP column types that I've read say that DATE cannot store fractional seconds.</div><br><div><blockquote type="cite"><div>On 1 Feb 2017, at 17:40, Frank Carnovale <<a href="mailto:frank.carnovale@gmail.com" target="_blank">frank.carnovale@gmail.com</a>> wrote:</div><br class="m_1694716395753057569Apple-interchange-newline"><div><span style="font-family:LucidaGrande;font-size:12px;font-style:normal;font-variant-caps:normal;font-weight:normal;letter-spacing:normal;text-align:start;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;float:none;display:inline!important">I presume deliberate.. in Oracle, the data type called 'date' is fully timestamp capable.</span></div></blockquote></div><br>
<br>
--
The Wellcome Trust Sanger Institute is operated by Genome Research
Limited, a charity registered in England with number 1021457 and a
company registered in England with number 2742969, whose registered
office is 215 Euston Road, London, NW1 2BE.
<br></div><br>______________________________<wbr>_________________<br>
List: <a href="http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class" rel="noreferrer" target="_blank">http://lists.scsys.co.uk/cgi-<wbr>bin/mailman/listinfo/dbix-<wbr>class</a><br>
IRC: <a href="http://irc.perl.org#dbix-class" rel="noreferrer" target="_blank">irc.perl.org#dbix-class</a><br>
SVN: <a href="http://dev.catalyst.perl.org/repos/bast/DBIx-Class/" rel="noreferrer" target="_blank">http://dev.catalyst.perl.org/<wbr>repos/bast/DBIx-Class/</a><br>
Searchable Archive: <a href="http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk" rel="noreferrer" target="_blank">http://www.grokbase.com/group/<wbr>dbix-class@lists.scsys.co.uk</a><br></blockquote></div><br></div>