Live SQL

Session 02

View All Public Scripts Login to Run Script

Script Name Session 02
Visibility Unlisted - anyone with the share link can access
Description No description provided
Contributor spittingfire@gmail.com
Created Tuesday May 23, 2017

Statement 1

create table t ( test1 varchar2(22) )

Table created.

Statement 2

insert into t values ( '07/23/2001 02:20:55 AM' )

1 row(s) inserted.

Statement 3

select to_char(test1, 'hh:mi:ss') 
     from t

ORA-01722: invalid number

More Details: https://docs.oracle.com/error-help/db/ora-01722

Additional Information

Database on OTN SQL and PL/SQL Discussion forums
Oracle Database
Download Oracle Database