How can I show system date in a field in a detailsview

[vanisudha2000]

Hello,
I am having a detailsview , which is accessing data from the database, there is a field which should show the system date in it, but I am not able to get that, Can you please help me ..

Thanks in advance.

 

[jbenson001]

How are you trying to show the system date, are you getting it from the db?

Jim

 

[vanisudha2000]

Actually I was not very clear,
I am having the following fields in my database
title varchar(50)
desc varchar(50)
createdtime datetime
expiredtime datetime
addminutes int

The user enters only title, desc and addminutes from the DetailsView (ASP>NET 2.0)and click on the insert button,

now i have to add these addminutes to createdtime which should be the system current datetime.
so , expiredtime = addminutes + createdtime

I am not able to find a way how I can do this, Can any one of you please help me ..

Thanks in advance.

 

[jbenson001]

In your stored procedure, use the dateadd() function if you are using sql server, you can read more about it in Books On Line.