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

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: 823

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

Download FREE API for Word, Excel and PDF in ASP.Net

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

I agree, here is the link: https://www.e-iceblue.com/Introduce/spire-office-for-net-free.html

Contact Us

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

© COPYRIGHT 2024 ASPSnippets.com ALL RIGHTS RESERVED.