fork download
copy 
  1. DELIMITER $$
  2.  
  3. CREATE FUNCTION calculate_f(date1 DATE, date2 DATE, y INT)
  4. RETURNS INT
  5. DETERMINISTIC
  6. BEGIN
  7.     DECLARE x INT;
  8.     DECLARE result INT;
  9.  
  10.     -- Oblicz różnicę dni
  11.     SET x = DATEDIFF(date2, date1);
  12.  
  13.     -- Oblicz f(x, y)
  14.     SET result = (POW(x, 2) - POW(y, 2)) / (x - y);
  15.  
  16.     RETURN result;
  17. END$$
  18.  
  19. DELIMITER ;
  20.  
Success #stdin #stdout #stderr 0.01s 5288KB
comments (?)
stdin
copy 
Standard input is empty
stdout
copy 
Standard output is empty
stderr
copy 
Error: near line 1: near "DELIMITER": syntax error
Error: near line 8: near "DECLARE": syntax error
Error: near line 11: near "SET": syntax error
Error: near line 14: near "SET": syntax error
Error: near line 16: near "RETURN": syntax error
Error: near line 17: near "END$$": syntax error
https://ideone.com/WTAzBc
language:
SQLite (sqlite 3.27.2)
created:
3 days ago
visibility:
public

Share or Embed source code

Discover > Sphere Engine API

The brand new service which powers Ideone!

Discover > IDE Widget

Widget for compiling and running the source code in a web browser!