Advertisement
VoronVU

Округление времени до 5 минут

Aug 27th, 2014
687
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. TRUNC (TO_DATE(ASA."Дата-время", 'YYYY-MM-DD HH24:MI:SS'), 'HH24') +
  2. TRUNC (TO_CHAR (TO_DATE(ASA."Дата-время", 'YYYY-MM-DD HH24:MI:SS'), 'MI') / 5) / (12 * 24)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement