Skip to content

Instantly share code, notes, and snippets.

@ezhov-da

ezhov-da/sql-oracle-Equals date.sql

Last active March 10, 2019 12:16
Show Gist options
  • Save ezhov-da/191b5a5978ef61d449c40456ef7c1a0f to your computer and use it in GitHub Desktop.
Save ezhov-da/191b5a5978ef61d449c40456ef7c1a0f to your computer and use it in GitHub Desktop.
Download ZIP
дата равна дате
Raw
sql-oracle-Equals date.sql
select * from TABLE where
--to_date(CREATION_DATE, 'DD-MM-YYYY') = to_date(sysdate, 'DD-MM-YYYY');
--trunc(CREATION_DATE) = trunc(sysdate);
--trunc(LASTDATE, 'YEAR') = trunc(sysdate, 'YEAR')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment