How to write date time functions

Accepted 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()))

0

Vulpes15y ago

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]

0

karthik parcha15y ago

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

0

karthik parcha15y ago

Thanks a lot

0

Vulpes15y ago

No problem Pravin :)

0

Pravin More15y ago

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

0

Pravin More15y ago

Hi Karthik,

if want it for SQL Server then here is query...........

select DATEADD(day,-90,DATEADD(MM,-12,GETDATE()))

Thanks,
Pravin.

0

Prabhu Raja15y ago

@vulpes, Great

0

Prabhu Raja15y ago

@Datta,

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

0

Datta Kharad15y ago

Hi

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

0

Prabhu Raja15y ago

Hi,

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

0