Convert a string date into datetime in Oracle

by

Try this:
TO_DATE('2011-07-28T23:54:14Z', 'YYYY-MM-DD"T"HH24:MI:SS"Z"')

More Related Contents:

  1. ORA-01861: literal does not match format string
  2. ORA-01843 Not a valid month
  3. Merging two tables in SQL [closed]
  4. I want to search job and salary from employee table but I am getting error like invalid relational operator [closed]
  5. Inner join vs Where
  6. How do I do top 1 in Oracle? [duplicate]
  7. How to declare variable and use it in the same Oracle SQL script?
  8. How to find the employee with the second highest salary?
  9. Are a CASE statement and a DECODE equivalent?
  10. SQL recursive query on self referencing table (Oracle)
  11. Why use a JOIN clause versus a WHERE condition?
  12. format interval with to_char
  13. Oracle SQL – Identify sequential value ranges
  14. SQL error “ORA-01722: invalid number”
  15. Get month name from date in Oracle
  16. OVER clause in Oracle
  17. SQL Error: ORA-00942 table or view does not exist
  18. How to count the number of occurrences of a character in an Oracle varchar value?
  19. PARTITION BY with and without KEEP in Oracle
  20. Different CURRENT_TIMESTAMP and SYSDATE in oracle
  21. How to return multiple rows from the stored procedure? (Oracle PL/SQL)
  22. How to extract week number in sql
  23. How to use Timestamp_to_scn and Scn_to_timestamp in Oracle?
  24. Using LIKE in an Oracle IN clause
  25. In Oracle, is it possible to INSERT or UPDATE a record through a view?
  26. How to check if a column exists before adding it to an existing table in PL/SQL?
  27. How can I solve ORA-00911: invalid character error?
  28. Why doesn’t Oracle SQL allow us to use column aliases in GROUP BY clauses?
  29. Exporting a CLOB to a text file using Oracle SQL Developer
  30. Oracle ‘Partition By’ and ‘Row_Number’ keyword

Leave a Comment