Hello All,
Iam using Oracle9i and iam having trouble in this query:
Iam actually trying to insert the contents of table called test into a table called demo,both are in the same database.
The query is:
INSERT INTO demo SELECT * from test where mytime >= to_date('2002-09-30 00:00:00','YYYY-MM-DD HH24:MI') and mytime < to_date('2002-10-03 00:00:00','YYYY-MM-DD HH24:MI');
When i execute this query i get the following error:
"date format picture string ends before the input"
What has to be done to correct this?
is the query wrong?
Regards
Roopa
