daily pastebin goal
26%
SHARE
TWEET

Untitled

a guest Jan 18th, 2019 53 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. FunctionName(10.02.2011) Result should be 31.01.2011
  2.    
  3. select <date> - datepart('day', <date>) - 1
  4.    
  5. select date(current_Date) - datepart('day', current_Date) - 1
  6.    
  7. select current_timestamp, current_timestamp - extract(day from current_timestamp)
  8.    
  9. 2012-10-05 13:35:05 2012-09-30 00:00:00
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