daily pastebin goal
51%
SHARE
TWEET

Untitled

a guest Sep 14th, 2018 40 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. Converting Integer time stamp into java date
  2. 1333125342
  3.    
  4. select DATEADD(ss, FlOOR(1333089223/86400)*86400, '1970-01-01 00:00:00') AS Date
  5.    
  6. 3/30/12 12:18:43 PM
  7.    
  8. String dateAsText = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss")
  9.                           .format(new Date(1333125342 * 1000L));
  10.    
  11. new java.util.Date(millis);
  12.    
  13. 3/30/12 12:18:43 PM
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