<div dir="ltr">I presume deliberate.. in Oracle, the data type called 'date' is fully timestamp capable.</div><div class="gmail_extra"><br><div class="gmail_quote">On 1 February 2017 at 16:42, 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">In SQL::Translator::Producer::<wbr>Oracle, used to produce the CREATE TABLE statements from my DBIx::Class defined schema, two timestamp columns I have defined as data_type timestamp, eg:<br>
<br>
last_modified => {<br>
data_type => 'timestamp',<br>
},<br>
<br>
are converted to date Oracle column types due to the %translate hash near the top of the file containing:<br>
<br>
date => 'date',<br>
datetime => 'date',<br>
time => 'date',<br>
timestamp => 'date',<br>
year => 'date',<br>
<br>
Is this deliberate? Any suggestions for an elegant workaround?<br>
<br>
Cheers, James<br>
<span class="HOEnZb"><font color="#888888"><br>
<br>
<br>
--<br>
The Wellcome Trust Sanger Institute is operated by Genome Research<br>
Limited, a charity registered in England with number 1021457 and a<br>
company registered in England with number 2742969, whose registered<br>
office is 215 Euston Road, London, NW1 2BE.<br>
<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>
</font></span></blockquote></div><br></div>