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

[Jorge Gonzalez]

Looks like an authoritative source is in order:

https://docs.oracle.com/cd/B19306_01/server.102/b14225/ch4datetime.htm

Watch for "TIMESTAMP Datatype" section. It says exactly that.

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.

BR

J.


El 01/02/17 a las 20:16, Frank Carnovale escribió:
> sorry.. I'm way out-of-date there (or is it out-of-timestamp).  Can't
> see an elegant fix either.
>
> On 1 February 2017 at 17:47, James Gilbert <jgrg at sanger.ac.uk
> <mailto:jgrg at sanger.ac.uk>> wrote:
>
>     Really? Comparisons of oracle DATE and TIMESTAMP column types that
>     I've read say that DATE cannot store fractional seconds.
>
>>     On 1 Feb 2017, at 17:40, Frank Carnovale
>>     <frank.carnovale at gmail.com <mailto:frank.carnovale at gmail.com>> wrote:
>>
>>     I presume deliberate.. in Oracle, the data type called 'date' is
>>     fully timestamp capable.
>
>
>     -- 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
>     <http://lists.scsys.co.uk/cgi-bin/mailman/listinfo/dbix-class>
>     IRC: irc.perl.org#dbix-class <http://irc.perl.org#dbix-class>
>     SVN: http://dev.catalyst.perl.org/repos/bast/DBIx-Class/
>     <http://dev.catalyst.perl.org/repos/bast/DBIx-Class/>
>     Searchable Archive:
>     http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk
>     <http://www.grokbase.com/group/dbix-class@lists.scsys.co.uk>
>
>
>
>
> _______________________________________________
> 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@lists.scsys.co.uk

-- 
Jorge González Villalonga
Ingeniero de Sistemas / Systems Engineer
Red Hat Certified Engineer #140-183-666
Móvil / Cell: (+34) 672 173 200

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.

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.scsys.co.uk/pipermail/dbix-class/attachments/20170201/6877c389/attachment-0001.htm>