How to write date time functions

Question

Hi How to write datetime function for adding oneyear and 90 days ago to the currentdate Thanks Karthik

Vulpes · Answer

Actually, the question has been asked in relation to SQL Server rather than C#, so the answer will be: SELECT DATEADD(day, -90, DATEADD(year, -1, GETDATE()))

Vulpes · Answer

If you mean that you want to show the date using format 01 (i.e. MM/DD/YY), then I'd try: SELECT CONVERT(VARCHAR(8), DATEADD(day, -90, DATEADD(year, -1, GETDATE())), 1) AS [MM/DD/YY]

karthik parcha · Answer

hi when i execute your query getting following output 2010-08-24 08:21:23.040 i want to show here date as 01 by default plz help me

karthik parcha · Answer

Thanks a lot

Vulpes · Answer

No problem Pravin :)

Pravin More · Answer

ohh sorry Vulpes......we post at same time....

Pravin More · Answer

Hi Karthik, if want it for SQL Server then here is query........... select DATEADD(day,-90,DATEADD(MM,-12,GETDATE())) Thanks, Pravin.

Prabhu Raja · Answer

@vulpes, Great

Prabhu Raja · Answer

@Datta, Try to post Answers that differ from previous thread. So, that be will really helpful.

Datta Kharad · Answer

Hi DateTime dtm = DateTime.Now.AddYears(-1).AddDays(-90);

Prabhu Raja · Answer

Hi, Label1.Text = DateTime.Now.AddYears(-1).AddDays(-90).ToString();

How to write date time functions

Answers (11)