The mailing list for listmasters using Sympa

[Paola Gatti <address@concealed>]

Hi all,

I'm using Sympa v.3.2.1 configured with user_data_source
equal to a database Oracle.

When I add a new subscriber to a list the subscription date
is right if I do it before 12 p.m , but if I do it in the afternoon
the date is written wrong, i.e., _one day forward_

The date on Oracle system is ok (I executed the command
select sysdate from dual)

May be there is something wrong in this List.pm's statement ?

$sql = 'to_date(to_char(round(%s/86400) + 
to_number(to_char(to_date(\'01/01/1970
\' ,\'dd/mm/yyyy\'), \'J\'))) || \':\' ||to_char(mod(%s,86400)), 
\'J:SSSSS\')';

Thanks a lot,

regards
Paola Gatti