Help for a SQL statement

hnh456

I have a table table1
vid vname vyear vmonth vday vhour vminute
001 james 2016 12 1 17 10
001 james 2016 12 1 20 12
001 james 2016 12 2 8 20

I want to delete the records of the time period based on the time period
example
2016/12/1 19:30-2016/12/2 8:30

After the implementation, the first two records are deleted. How do I write this statement!

暗夜执行官

delete from table1 where to_date (vyear || '/' || vmonth || '/' || vday || '' || vhour || ':' || vminute, 'yyyy / mm / dd hh24: mi') between to_date ('2016/12/1 19:30', 'yyyy / mm / dd hh24: mi') and to_date ('2016/12/2 8:30', 'yyyy / mm / dd hh24: mi') ;

hnh456

暗夜执行官Hello
I executed your statement but there was an error

ORA-01847: The number of times in the month must be between 1 and the last day of the month.

sanshuimei

Check the VDAY field in your table to see if it exceeds the last day of the month
For example, there will be no 30th in February
Or stitch them together to check

hnh456

Really likesanshuimeisaid
In December, there was a record of vday = 32, deleted ok.

Thank暗夜执行官,sanshuimei