SQLTeam.com | Weblogs | Forums

To extract date part from dateandtime in toad


#1

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


#2

Post the DDL for the tables you're querying and a small number of rows in the form of insert statement(s)..