Skip to content

Instantly share code, notes, and snippets.

@ezhov-da

ezhov-da/sql-oracle-Convert varchar to date.sql

Last active March 10, 2019 12:17
Show Gist options
  • Save ezhov-da/b09e17ed269e5cd2be8a417065279ff3 to your computer and use it in GitHub Desktop.
Save ezhov-da/b09e17ed269e5cd2be8a417065279ff3 to your computer and use it in GitHub Desktop.
Download ZIP
sql oracle convert varchar to date
Raw
sql-oracle-Convert varchar to date.sql
--https://www.techonthenet.com/oracle/functions/to_date.php
SELECT TO_DATE('2015/05/15 8:30:25', 'YYYY/MM/DD HH:MI:SS') FROM dual;
SELECT TO_DATE('20150515_18:30:25', 'YYYYMMDD_HH24:MI:SS') FROM dual;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment