Select Code to Download

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