database table problem

[arjundass]

I have added a new table to database .

I have added some fields to it , User id , order id , creation id and i also need to add a expiration date field to it.

HOw do i add expiration date field ?

I have products which have subscribing option of 1 month , 3 month , 6 month , 12 month .

I want expiration field to be automatically calculated according to the option selected by the customer.

Please help with this expiration field code ????

Thanks.

[arjundass]

I have added a new table to database .

I have added some fields to it , User id , order id , creation id and i also need to add a expiration date field to it.

HOw do i add expiration date field ?

I have products which have subscribing option of 1 month , 3 month , 6 month , 12 month .

I want expiration field to be automatically calculated according to the option selected by the customer.

Please help with this expiration field code ????

Thanks.

[arjundass]

Any Help ..Please...

[ruby1058]

I think this is why I again am trying to make the database column, variable type, but I'm sure I'm not wrong. Everything seems to go fine as data types, and everything as long as I continued to use the database to create a column works. Even SQL Server database I'm using it is working fine, but it is error for Oracle database.