Re: [Maria-developers] MDEV-11829 RFC3339 Support

2017-03-05 Thread Alexander Barkov
Hello Seth, I added a comment into the pull request: https://github.com/MariaDB/server/pull/290 Please have a look. Thanks! On 02/21/2017 04:37 PM, Seth Shelnutt wrote: Sergei, Thank you for your time and responses. On Tue, Feb 14, 2017 at 3:11 PM Sergei Golubchik mailto:s...@mariadb.org>>

Re: [Maria-developers] MDEV-11829 RFC3339 Support

2017-02-21 Thread Sergei Golubchik
Hi, Seth! On Feb 21, Seth Shelnutt wrote: > > > > To support TIMESTAMP WITH TIME ZONE and TIME WITH TIME ZONE literals > > (literals only, not expressions or fields or variables), it would be > > enough to parse them in str_to_datetime(), there is no need to > > return the time zone back to the ca

Re: [Maria-developers] MDEV-11829 RFC3339 Support

2017-02-21 Thread Seth Shelnutt
Sergei, Thank you for your time and responses. On Tue, Feb 14, 2017 at 3:11 PM Sergei Golubchik wrote: > Hi, Seth! > > > > It's not what SQL standard specifies. It says, > <...> whenever a datetime value without time zone is to be implicitly > derived from one with, SQL assumes the value

Re: [Maria-developers] MDEV-11829 RFC3339 Support

2017-02-14 Thread Sergei Golubchik
Hi, Seth! On Feb 02, Seth Shelnutt wrote: > Hello, > > This is in response to the comments on the initial pull request I made > for adding RFC3339 support [1]. > > The proposal is to add support for parsing RFC3339 and then use the > given timezone offset to shift the datetime. I think most use