[Dbix-class] SQL::Translator::Producer::Oracle turns timestamp data_type to date

[Frank Carnovale]

I presume deliberate.. in Oracle, the data type called 'date' is fully
timestamp capable.

On 1 February 2017 at 16:42, James Gilbert <jgrg at sanger.ac.uk> wrote:

> In SQL::Translator::Producer::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:
>
>     last_modified => {
>         data_type => 'timestamp',
>     },
>
> are converted to date Oracle column types due to the %translate hash near
> the top of the file containing:
>
>     date       => 'date',
>     datetime   => 'date',
>     time       => 'date',
>     timestamp  => 'date',
>     year       => 'date',
>
> Is this deliberate?  Any suggestions for an elegant workaround?
>
>         Cheers,  James
>
>
>
> --
>  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.
>
> _______________________________________________
> List: http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class
> IRC: irc.perl.org#dbix-class
> SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
> Searchable Archive: http://www.grokbase.com/group/
> dbix-class at lists.scsys.co.uk
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20170201/2b74de40/attachment.htm>