search

JuliaDatabases / JDBC.jl

Julia interface to Java database drivers
Other
38 stars 19 forks source link

Missing column type constant #42

Open amellnik opened 6 years ago

amellnik commented 6 years ago

I'm using JDBC.jl with an Oracle 12c database and it looks like a column type that I'm using (TIMESTAMP WITH LOCAL TIMEZONE) is missing from this list: https://github.com/JuliaDatabases/JDBC.jl/blob/master/src/JDBC.jl#L497

I know the value (-102) and can create a pull request to add it, but I wanted to check -- is there a list of all these possible values somewhere? I haven't been able to find it, but it's possible I'm not searching with the right phrases.

aviks commented 6 years ago

No, I haven't found anything authoritative.

amellnik commented 6 years ago

I found one more which is -104 and it corresponds to the oracle type INTERVAL DAY TO SECOND(11). I don't know how general it is, but it returns values in the SQL standard interval format like 3 4:05:06. Do we want to try to convert these to native Julia time intervals or just leave them as strings?