Split Date into Day Month and Year and INSERT using SQL Query

nedash

SOLVED CLOSED ACTIVE ANSWERED
User: nedash
Posted: on Jun 26, 2013 06:43 AM
Forum: SQL Server
Answer: 1
Views: 7673

hi I have Date table in database

Id	Year	Month	day

I want when users click on button in DAte tabel in year column save Current Year in Month Column save Current Month and in Day column save current day

I used GETDATE() function before but it save whole date in 1 column I want it save Year-Month-day in seprate Column How I can do it?

Best Regards

Neda

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

Mudassar

0 1

Reply
ANSWER
User: Mudassar
Replied: on Jun 26, 2013 06:45 AM
Report

You can easily extract Year, Month and Day from GETDATE()

INSERT INTO TBL
VALUES(1, DATEPART(YEAR, GETDATE()), DATEPART(MONTH, GETDATE()), DATEPART(DAY, GETDATE()))

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

Split Date into Day Month and Year and INSERT using SQL Query

Company

Explore

Follow us

Contact Us