my $foo = <<"END";
  DATE_ADD( DATE(ts), INTERVAL TIME_TO_SEC(ts)-TIME_TO_SEC(ts)%$span_sec second)                                                                                        
  #This is some database query 
END
#ts and span_sec are some scalar values