Is this support (fraction of second) there in other RDBMS (Oracle, MSSQL, etc?). If it is only Mysql 5.6.4 +, then we shouldn't use IMO. If this support is there in all other RDBMS, then it should be ok.
On Thu, Oct 1, 2015 at 9:40 PM, Ishara Karunarathna <isha...@wso2.com> wrote: > Hi Shankar, > > On Thu, Oct 1, 2015 at 7:45 PM, Selvaratnam Uthaiyashankar < > shan...@wso2.com> wrote: > >> Normally, we should keep the compatibility with older versions. >> >> Is there any specific reason why you need upto microsecond precision for >> the timestamp? >> > by default mysql support for seconds. > In Identity server we started to persist session date with its updated > timestamp. And retrieve the latest data object related to > given session. > If it's only supported for seconds we get duplicate entries. In that case > we have to go for fractional seconds in timestamp > or will have to store it in another data type. > > Thanks, > Ishara > >> >> On Wed, Sep 30, 2015 at 10:35 PM, Ishara Karunarathna <isha...@wso2.com> >> wrote: >> >>> Hi all, >>> >>> For example In mysql version 5.6.4 (released on February 5, 2013 ) >>> onwards [1] it support for >>> fractional seconds for TIMESTAMP values, with up to microseconds (6 >>> digits) >>> >>> But if we write scripts to get that features it won't work with older >>> versions. >>> So can we write scripts to work only with mysql version 5.6.4 and latest >>> or should we support for old versions ?. >>> >>> Thanks, >>> Ishara >>> >>> [1] >>> http://dev.mysql.com/doc/refman/5.6/en/mysql-nutshell.html#mysql-nutshell-additions >>> -- >>> Ishara Karunarathna >>> Senior Software Engineer >>> WSO2 Inc. - lean . enterprise . middleware | wso2.com >>> >>> email: isha...@wso2.com, blog: isharaaruna.blogspot.com, mobile: >>> +94717996791 >>> >> >> >> >> -- >> S.Uthaiyashankar >> VP Engineering >> WSO2 Inc. >> http://wso2.com/ - "lean . enterprise . middleware" >> >> Phone: +94 714897591 >> > > > > -- > Ishara Karunarathna > Senior Software Engineer > WSO2 Inc. - lean . enterprise . middleware | wso2.com > > email: isha...@wso2.com, blog: isharaaruna.blogspot.com, mobile: > +94717996791 > -- S.Uthaiyashankar VP Engineering WSO2 Inc. http://wso2.com/ - "lean . enterprise . middleware" Phone: +94 714897591
_______________________________________________ Dev mailing list Dev@wso2.org http://wso2.org/cgi-bin/mailman/listinfo/dev