Re: [SQL] date function problem

Dnia 2004-02-03 16:51, Użytkownik [EMAIL PROTECTED] napisał: Hi All I have an expiration_date column in my table with data type as timestamp. I need to set that as one year after the current time. how do i do that. I am getting a casting problem whenever i try something. something like now()+ 1 yea

Re: [SQL] date function problem

--On Tuesday, February 03, 2004 10:51:45 -0500 [EMAIL PROTECTED] wrote: Hi All I have an expiration_date column in my table with data type as timestamp. I need to set that as one year after the current time. how do i do that. I am getting a casting problem whenever i try something. something lik

[SQL] date function problem

Hi All I have an expiration_date column in my table with data type as timestamp. I need to set that as one year after the current time. how do i do that. I am getting a casting problem whenever i try something. something like now()+ 1 year. Please let me know --mohan --