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

James Gilbert jgrg at sanger.ac.uk
Wed Feb 1 16:42:02 GMT 2017


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. 



More information about the DBIx-Class mailing list