Sir,
I have created a table with 3 columns as below:
dtFrom datetime NOT NULL,
dtTo datetime NOT NULL,
service_time int NOT NULL,
Now, I would need to insert datetime in dtFrom & dtTo columns. Date that I would need to insert is as 22-Mar-2018. But on inserting it keeps on saving date as 1988-03-01 00:00:00.000
I have used below query:
insert into tbl_prev_policy_issued_before(dtFrom,dtTo,service_time)
values(
REPLACE(CONVERT(VARCHAR(11), '01 Mar 1988', 106), ' ', '-'),
REPLACE(CONVERT(VARCHAR(11), '01 Apr 1990', 106), ' ', '-'),
55)
How should I save the date as 22-Mar-2018 this format. ?