Timezone offset ignored when loading into sqlite

[peterdesmet]

Timezone offset ignored when loading into sqlite

[roll]

Hi,

Have you tried it with Frictionless?

This is a legacy codebase

[peterdesmet]

No, do you mean using to_spss()? In the documentation I see:

Wriring to SQL [sic]

[NOTE] Timezone information is ignored for datetime and time types.

[roll]

@peterdesmet
It's a typo in the SQL Tutorial - package.to_sql - https://github.com/frictionlessdata/frictionless-py/blob/master/tests/plugins/test_sql.py#L123

But yes the timezones don't seem to be supported

[roll]

We have an issue for it - frictionlessdata/frictionless-py#405 - but not yet ready

[peterdesmet]

Thanks, will close this issue here in favour of the other issue.