Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- TRUNC (TO_DATE(ASA."Дата-время", 'YYYY-MM-DD HH24:MI:SS'), 'HH24') +
- 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