Retrieve successfully executed time or server processing time

Hi Experts,

Could you please let me know how to get values of server processing time or successfully executed time when any view is executed using select statement. I want to know from which table i can get execution time of the select statement.

I know from sql console we can get it but i want to know how it is being calculated/retrieved from table. I want to update these execution/server processing times in a custom table on a regular basis.

BestRegards

sasi