.TO_CHAR problem - Mailing list pgsql-general

Hi all,

I want to have some stats from my data grouped by 2hours periodes.

Here is the query :

SELECT TO_DATE(TO_CHAR    (date_clic,'DD-MM-YYYY ')
        ||     (TO_CHAR(
                TO_NUMBER(
                    TO_CHAR(date_clic,'hh24')
                , 99)
                     - mod(
                         TO_NUMBER(
                             TO_CHAR(date_clic,'hh24')
                         , 99)
                     ,2)
                 , 'hh24')
                 )
             ||':00','DD-MM-YYYY HH24:MI') AS date_debut
FROM clic_campagne;

But I only get the date whithout the hours and the minute, how can I get
them ?

Thanx,

Guillaume.