Skip to content

Instantly share code, notes, and snippets.

@ezhov-da

ezhov-da/sql-oracle-Работа со временем.sql

Last active March 10, 2019 12:14
Show Gist options
  • Save ezhov-da/a5e9688ea6b031b90a8760a768e96324 to your computer and use it in GitHub Desktop.
Save ezhov-da/a5e9688ea6b031b90a8760a768e96324 to your computer and use it in GitHub Desktop.
Download ZIP
работа со временем
Raw
sql-oracle-Работа со временем.sql
select
sysdate,
EXTRACT(HOUR from cast(sysdate as timestamp)),
EXTRACT(MINUTE from cast(sysdate as timestamp)),
to_char(sysdate, 'hh24'),
to_char(sysdate, 'mi')
from DUAL t0;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment