SQL delete and update

[chennupriya]

Hi All,

I have a problem when i run a sas code it will delete the current table and insert into same table like in example below but the problem is its changing all the dates format to 1960-01-01 05:38:21.000 

can anyone pls help 

i have used below query 

proc sql;
delete from sqldb.xy;
insert into sqldb.xy
select * from price.yz
;
quit;

[ballardw]

By any chance is any of this data in another database such as Oracle, DB2 or SQL server?

There are a lot of systems out there that say something is a "date" but is actually a datetime. The specific value you show makes me beleive that you actually have a date, 08/01/2015, as a value being inserted into something that is expecting a datetime value.

[chennupriya]

yes you are rite but for first time its working fine and loading correct dates i mean 

PROC SQL;
CREATE TABLE sqldb.xy  AS
SELECT 
FROM price.yz;
quit;

/*inorder to update table in sql */

proc sql;
delete from sqldb.xy;
insert into sqldb.xy
select * from price.yz
;
quit;

for the first time ia m using proc sql create table in sql but once the table is created in sql then when i run second time i am just deleteing table and inserting rows into same table but when i am doing secong procedure teh dtae format changes pls explain