<html><head><meta http-equiv="Content-Type" content="text/html charset=us-ascii"></head><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space;" class=""><div class="">Really? Comparisons of oracle DATE and TIMESTAMP column types that I've read say that DATE cannot store fractional seconds.</div><br class=""><div><blockquote type="cite" class=""><div class="">On 1 Feb 2017, at 17:40, Frank Carnovale <<a href="mailto:frank.carnovale@gmail.com" class="">frank.carnovale@gmail.com</a>> wrote:</div><br class="Apple-interchange-newline"><div class=""><span style="font-family: LucidaGrande; font-size: 12px; font-style: normal; font-variant-caps: normal; font-weight: normal; letter-spacing: normal; orphans: auto; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: auto; word-spacing: 0px; -webkit-text-stroke-width: 0px; float: none; display: inline !important;" class="">I presume deliberate.. in Oracle, the data type called 'date' is fully timestamp capable.</span></div></blockquote></div><br class="">
<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></body></html>