Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on Aug 11th, 2012  |  syntax: None  |  size: 0.40 KB  |  hits: 8  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. DELIMITER $$
  2.  
  3. USE `silverjet`$$
  4.  
  5. DROP FUNCTION IF EXISTS `WspanToDate`$$
  6.  
  7. CREATE FUNCTION `WspanToDate`(c TIMESTAMP, f TEXT) RETURNS TEXT
  8. BEGIN
  9. DECLARE MM INT;
  10. DECLARE DD INT;
  11. DECLARE YY INT;
  12.  
  13. SET MM = MONTH(STR_TO_DATE(f, "%d%M"));
  14. SET DD = DAY(STR_TO_DATE(f, "%d%M"));
  15. SET YY = YEAR(c);
  16.  
  17. IF MM < MONTH(c) THEN SET YY = YY + 1;
  18. END IF;
  19.  
  20. RETURN CONCAT(YY, '-', MM, '-', Dd);
  21. END$$
  22.  
  23. DELIMITER
create a new version of this paste RAW Paste Data