Facepalm (current timestamp)

GeniusController.php

<?php
/**
 * Created by PhpStorm.
 * User: morontt
 * Date: 08.05.14
 * Time: 12:15
 */

namespace Ultrasoft\SuperBundle\Controller;

use Symfony\Bundle\FrameworkBundle\Controller\Controller;
use Symfony\Component\HttpFoundation\Response;

class GeniusController extends Controller
{
    /**
     * @return Response
     */
    public function indexAction()
    {
        $currentTimestamp = $this->getCurrentTimestamp();

        return $this->render(
            'UltrasoftSuperBundle:Genius:index.html.twig',
            array(
                'timestamp' => $currentTimestamp,
            )
        );
    }

    /**
     * @return string
     */
    private function getCurrentTimestamp()
    {
        $em = $this->container->get('doctrine')->getEntityManager();
        $rez = $em->getConnection()->fetchAssoc('SELECT CURRENT_TIMESTAMP() as current_datetime;');

        return $rez['current_datetime'];
    }
}