Answers for "to date oracle with time"

SQL
4

to date oracle with time

-- TO_TIMESTAMP(date_string,'YYYY-MM-DD HH24:MI:SS')
SELECT TO_TIMESTAMP('2021-02-21 23:12:01','YYYY-MM-DD HH24:MI:SS') FROM DUAL;
Posted by: Guest on March-16-2021
2

oracle to date

SELECT
  TO_DATE( '5 Jan 2017', 'DD MON YYYY' )
FROM
  dual;

---or----
INSERT INTO members(first_name, last_name, joined_date)
VALUES('Laureen','Davidson', TO_DATE('Feb 01 2017','Mon DD YYYY'));
Posted by: Guest on September-28-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language