حضرت خواجہ سیدنا معین الدین حسن چشتی سنجاری اجمیری رحمۃ اللہ علیہ

SQL Server: Only Add Day and not update Time

ramco1917

ramco191...

SOLVED CLOSED ACTIVE ANSWERED
User: ramco1917
Posted: on Mar 31, 2023 06:52 AM
Forum: SQL Server
Answer: 1
Views: 1731

Hi

I have below value in Database. It is DateTime field. Database is Sql. I want to add 2 weeks in Date, other values remain same.

2023-04-01 15:15:00.000

Thanks

AjayV

AjayV

0 1

Reply
ANSWER
User: AjayV
Replied: on Mar 31, 2023 07:16 AM
Report

Hi ramco1917,

You can use DATEADD function to add days.

Please use below query.

SQL

SELECT DATEADD(DAY,14,DateTimeColumn) AS DateTimeColumn FROM DateTimeTable

Contact Us

Email: webmaster@aspsnippets.com
Address:
ASPSNIPPETS PRIVATE LIMITED
G-110, SHAGUN ARCADE,
MALAD (EAST),
MUMBAI, MAHARASHTRA,
INDIA 400097.

© COPYRIGHT 2026 ASPSnippets.com ALL RIGHTS RESERVED.