Oracle to_date method, show did not selected row, but there are tables, can look up to the date of the corresponding data at the same time, but don't know why the to_date method failed, this date with the implicit conversion of the string also may not be able to check

CodePudding user response:

All the data and statements, you stick up, to create and insert form,

CodePudding user response:

The problem is you select statement didn't find any data,
Recommend you use to connect the oracle client software, than up sqlplus works, such as the toad or oracle SQL developer

CodePudding user response:

Where hiredate=to_date (' 00 00 00 - month - ');
Or
Where to_char (hiredate, 'yy' 'mm' 'dd')='00' '00' '00';
End this post

CodePudding user response:

The

reference 3 floor weixin_45366212 response:

where hiredate=to_date (' 00 00 00 - month - ');
Or
Where to_char (hiredate, 'yy' 'mm' 'dd')='00' '00' '00';
This post end

To_date () content in brackets is fixed into the Oracle of the current table shown in the form

CodePudding user response:

reference 1st floor selling fruit net reply:

your data and statements, all post, to create and insert forms,

The create table emp (
Empno int,
Ename varchar2 (12),
Hiredate date,
Sal int,
Com int,
Deptno int);

Insert into emp (1, 'zhang' sysdate - 365200, 0600, 1);


);

CodePudding user response:

reference 4 floor meiling_CSDN response:

Quote: reference weixin_45366212 reply: 3/f

where hiredate=to_date (' 00 00 00 - month - ');
Or
Where to_char (hiredate, 'yy' 'mm' 'dd')='00' '00' '00';
This post end

To_date () content in brackets is fixed into the Oracle of the current table shown in the form, please

Don't use the same format must to explain how to sort your machine, machine is dead after all, such as
Where hiredate=to_date (' 19990101 ', 'yyyymmdd'); Or
Where hiredate=to_date (' 1999-01-01 ', '- dd yyyy - mm); Otherwise must display format error

CodePudding user response:

Where hiredate=to_date (' 1999-01-01 ', '- dd yyyy - mm);