Change view path to absolute path
Change db timestamp to datetime