Thanks for the reply ,
I didn't look at the formatted data download in kibana , it is showing me date in the UTC format rather than the UNIX format which is shown in Raw download in kibana.
I tried the scripted field too, as it is mentioned resource intensive which is so slow for retrieving results.