Convert a string date into datetime in Oracle

Question

How can I convert this string date to datetime in oracle   2011-07-28T23 54 14Z   Using this code throws an error   TO DATE  2011-07-28T23 54 14Z     YYYY-MM-DD HH24 MI SS     How can this be done   Error report  SQL Error  ORA-01861  literal does not match format string 01861  00000 -   literal does not match format string   Cause     Literals in the input must be the same length as literals in            the format string  with the exception of leading whitespace    If the             FX  modifier has been toggled on  the literal must match exactly             with no extra whitespace   Action    Correct the format string to match the literal    Update -  TO DATE  2011-07-28T23 54 14Z    YYYY-MM-DD T HH24 MI SS Z     I only see the date not time in the column  28-JUL-11

User · Answer

You can use a cast to char to see the date results    x000D   x000D   select to char to date  17-MAR-17 06 04 54   dd-MON-yy hh24 mi ss     mm dd yyyy hh24 mi ss   from dual  x000D   x000D   x000D

User · Answer

Hey I had the same problem  I tried to convert  2017-02-20 12 15 32  varchar to a date with TO DATE  2017-02-20 12 15 32   YYYY-MM-DD HH24 MI SS   and all I received was 2017-02-20 the time disappeared  My solution was to use TO TIMESTAMP  2017-02-20 12 15 32   YYYY-MM-DD HH24 MI SS   now the time doesn t disappear

User · Answer

Try this  TO DATE  2011-07-28T23 54 14Z     YYYY-MM-DD T HH24 MI SS Z

[sql] Convert a string date into datetime in Oracle

Examples related to sql

Examples related to oracle

Examples related to ora-01861