I have query like
i have to inserty records from my select query to a table
insert into table A
Select * frrom table B where
and yrmonth = 201610 and
LOAD_TSTMP = 12/8/2016
How can I extract only data form date and time form timestamp in Toad
When I am specifying the yearmonth it is taking all 2500 records which I dont need to insert..
I have to insert only records on year month =201610 and loaded timestamp=12/8/2016
12/8/2016 is in mm/dd/yyyy format