Advertisement
Guest User

Untitled

a guest
Jun 27th, 2019
83
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.30 KB | None | 0 0
  1. SELECT TO_CHAR(SYSDATE, 'Dy, RM, D, YEAR AD, DDD "Day of the year ", SSSSS')
  2. || ' Seconds past midnight' "NOW"
  3. FROM DUAL;
  4.  
  5.  
  6.  
  7. NOW
  8. ----------------------------------------------------------------------------------
  9. Fri, IV , 6, TWENTY NINETEEN AD, 109 Day of the year , 54236 Seconds past midnight
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement