<html>
<head>
<meta content="text/html; charset=windows-1252"
http-equiv="Content-Type">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p>Looks like an authoritative source is in order:</p>
<p><a class="moz-txt-link-freetext" href="https://docs.oracle.com/cd/B19306_01/server.102/b14225/ch4datetime.htm">https://docs.oracle.com/cd/B19306_01/server.102/b14225/ch4datetime.htm</a></p>
<p>Watch for "TIMESTAMP Datatype" section. It says exactly that.</p>
<p>So I guess SQL::Translator::Producer::Oracle is not right, and in
fact, since TIMESTAMP is an extension to the DATE datatype (see
former link) it would be more correct to map all datetime types in
S::T::P::O to "timestamp" type.</p>
<p>BR</p>
<p>J.<br>
</p>
<br>
<div class="moz-cite-prefix">El 01/02/17 a las 20:16, Frank
Carnovale escribió:<br>
</div>
<blockquote
cite="mid:CANYb_mj5g+AegHN6uu7pbAobV0LbLGZ8M6AGAEQgtXSj_f661g@mail.gmail.com"
type="cite">
<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 moz-do-not-send="true"
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
moz-do-not-send="true"
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 moz-do-not-send="true"
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 moz-do-not-send="true"
href="http://irc.perl.org#dbix-class" rel="noreferrer"
target="_blank">irc.perl.org#dbix-class</a><br>
SVN: <a moz-do-not-send="true"
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 moz-do-not-send="true"
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>
<br>
<fieldset class="mimeAttachmentHeader"></fieldset>
<br>
<pre wrap="">_______________________________________________
List: <a class="moz-txt-link-freetext" href="http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class">http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class</a>
IRC: irc.perl.org#dbix-class
SVN: <a class="moz-txt-link-freetext" href="http://dev.catalyst.perl.org/repos/bast/DBIx-Class/">http://dev.catalyst.perl.org/repos/bast/DBIx-Class/</a>
Searchable Archive: <a class="moz-txt-link-freetext" href="http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk">http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk</a></pre>
</blockquote>
<br>
<div class="moz-signature">-- <br>
<div style="float: left; font-face: Verdana; color: black; margin:
20px; "> <span style="font-style: italic; font-weight: bold;">
Jorge González Villalonga<br>
</span> Ingeniero de Sistemas / Systems Engineer<br>
Red Hat Certified Engineer #140-183-666<br>
Móvil / Cell: (+34) 672 173 200<br>
</div>
<div style="clear: both;">
<div style="width: 900px; margin: 15px; -moz-border-radius:
10px;
border-radius: 10px; background-color: #dcdcdc">
<p style="font-face: Verdana; font-size: 85%; text-align:
justify; color: #555; padding: 10px;"> La información
contenida en este mensaje y/o archivo(s) adjunto(s) es
confidencial/privilegiada y está destinada a ser leída sólo
por la(s) persona(s) a la(s) que va dirigida. Si usted lee
este mensaje y no es el destinatario señalado, el empleado o
el agente responsable de entregar el mensaje al
destinatario, o ha recibido esta comunicación por error, le
informamos que está totalmente prohibida, y puede ser
ilegal, cualquier divulgación, distribución o reproducción
de esta comunicación. Le rogamos que nos lo notifique
inmediatamente y nos devuelva el mensaje original a la
dirección arriba mencionada. Gracias. </p>
</div>
</div>
</div>
</body>
</html>