<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body bgcolor="#FFFFFF" text="#000000">
<p>We're only using DATE columns in our schemas as we don't need subsecond precision but you're right, 'TIMESTAMP' and 'TIMESTAMP WITH TIME ZONE' are different datatypes and should be treated as such.</p>
<p>Patch for the mapping welcome!</p>
<p>Best regards, Alex<br>
</p>
<br>
<div class="moz-cite-prefix">On 2017-02-01 20:35, Jorge Gonzalez wrote:<br>
</div>
<blockquote cite="mid:25ca1591-a848-a966-7b61-8efcb289a0dd@daikon.es" type="cite">
<p>Looks like an authoritative source is in order:</p>
<p><a moz-do-not-send="true" 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 moz-do-not-send="true" 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 moz-do-not-send="true" 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 moz-do-not-send="true" 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>
<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>
<br>
<font face="Verdana" color="Purple" size="2"><br>
*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*<br>
T-Systems Austria GesmbH Rennweg 97-99, 1030 Wien<br>
Handelsgericht Wien, FN 79340b<br>
*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*<br>
Notice: This e-mail contains information that is confidential and may be privileged.<br>
If you are not the intended recipient, please notify the sender and then<br>
delete this e-mail immediately.<br>
*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*<br>
</font>
</body>
</html>