Skip to content

Instantly share code, notes, and snippets.

@theothermattm

theothermattm/oracle-to-date.sql

Created March 8, 2013 21:28
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save theothermattm/5120027 to your computer and use it in GitHub Desktop.
Save theothermattm/5120027 to your computer and use it in GitHub Desktop.
Download ZIP
Oracle to_date with hour and minutes
Raw
oracle-to-date.sql
select * from my_table where my_date_time > to_date('08-03-2013 16:00','dd-MM-yyyy HH24:MI') order by my_date_time;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment