SHARE
TWEET

phatmatt2

a guest Jan 22nd, 2020 61 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. DELIMITER |
  2. CREATE FUNCTION F_AS_DATE_2 (return_date DATE)
  3.   RETURNS VARCHAR(20)
  4.    DETERMINISTIC
  5.     BEGIN
  6.      DECLARE sf_value VARCHAR(20);
  7.         sf_value = DATE_FORMAT(STR_TO_DATE(DATE,'%Y%m%d'),'%m/%d/%Y');
  8.      RETURN sf_value;
  9.     END|
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Top