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
_______________________________________________
Dev mailing list
Dev@wso2.org
http://wso2.org/cgi-bin/mailman/listinfo/dev

Reply via email to