How to query when the date greater than 3999.12.31? In the database are dates, greater than '3999.12.31'. Those values are not appear in SELECT statement.
Please help me
Éva
Asked
Active
Viewed 3,350 times
-3
-
Please read http://stackoverflow.com/help/how-to-ask. The quality of the answers is very much dependent on the quality of the question. – Rob van Laarhoven May 19 '14 at 12:06
1 Answers
2
What do you mean? No problems here (Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production ):
create table testdate (d date);
insert into testdate values (to_date('21-01-5001','DD-MM-YYYY'));
select * from testdate where d > to_date('31-12-3999','DD-MM-YYYY');
D
-------------------
21-01-5001 00:00:00
Rob van Laarhoven
- 8,737
- 2
- 31
- 49
-
-
1@user3652065 What is not work? We do not have a crystal ball. In order to help you we need more information then this. – Rob van Laarhoven May 19 '14 at 11:28
-
@user3652065 What tools are you using to run the queries? It may be an issue with the IDE, language, or library you are using. – Jon Heller May 19 '14 at 19:08