Hakkan Lui wrote:
>Dear all,
>
>How can I change the year of the date field using sql statement?
>
>It means something like:
>update table1 set year(f1) = '2002' where year(f1) = '2003';
>
>
If you have a field for _just_ the year, you can use the above statement.
If you have the year embedded i
--- Original Message -
From: "Hakkan Lui" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, January 05, 2003 10:12 PM
Subject: Update Year of Date Field using sql statement
Dear all,
How can I change the year of the date field using sql statement?
It means s
t: Sunday, January 05, 2003 10:12 PM
Subject: Update Year of Date Field using sql statement
> Dear all,
>
> How can I change the year of the date field using sql statement?
>
> It means something like:
> update table1 set year(f1) = '2002' where year(f1) = '2003
Dear all,
How can I change the year of the date field using sql statement?
It means something like:
update table1 set year(f1) = '2002' where year(f1) = '2003';
Thanks for anyone's help.
Regards,
Hakkan Lui
-
Before postin