Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 7 of 7 total

Tue, Oct 13 2009 11:44 PM	Permanent Link
"Rita"	The following code is ok for one day how can i make it work for everyday. So i dont have to change the day eachtime. ############################################### UPDATE MYFILE SET DAY = 'Monday' WHERE EXTRACT(DAYOFWEEK FROM DATE) = 1 ############################################### Thanks Rita
Wed, Oct 14 2009 2:23 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	Rita I'm not 100% sure what you want to achieve but try CURRENT_DATE Roy Lambert
Wed, Oct 14 2009 4:25 AM	Permanent Link
"John Hay"	Rita > The following code is ok for one day > how can i make it work for everyday. > So i dont have to change the day eachtime. > > ############################################### > UPDATE MYFILE > SET DAY = 'Monday' > WHERE EXTRACT(DAYOFWEEK FROM DATE) = 1 > ############################################### How about UPDATE MyFile SET Day= IF(EXTRACT(DAYOFWEEK FROM DATE) = 1 THEN 'Monday' ELSE IF(EXTRACT(DAYOFWEEK FROM DATE) = 2 THEN 'Tuesday' ELSE IF(EXTRACT(DAYOFWEEK FROM DATE) = 3THEN 'Wednesday' ELSE IF(EXTRACT(DAYOFWEEK FROM DATE) = 4 THEN 'Thursday' ELSE IF(EXTRACT(DAYOFWEEK FROM DATE) = 5 THEN 'Friday' ELSE IF(EXTRACT(DAYOFWEEK FROM DATE) = 6 THEN 'Saturday' ELSE 'Sunday')))))) John
Wed, Oct 14 2009 8:27 AM	Permanent Link
Roy Lambert NLH Associates Team Elevate	John OK, but how good are you at reading your wife's mind? Roy Lambert
Wed, Oct 14 2009 8:46 AM	Permanent Link
"John Hay"	Roy > OK, but how good are you at reading your wife's mind? I would say fantastic but I suspect she might say "could do better..." John
Wed, Oct 14 2009 2:55 PM	Permanent Link
"Rita"	"Roy Lambert" <roy.lambert@skynet.co.uk> wrote in message news:7C211DDD-9C4D-47FA-9E6C-4931D4E021C6@news.elevatesoft.com... > Rita > > > I'm not 100% sure what you want to achieve but try CURRENT_DATE > Sorry Roy i thought it was obvious. Rita
Wed, Oct 14 2009 2:59 PM	Permanent Link
"Rita"	I knew I would get a nice if else from u John. Thanks you understood me I guess Roy just doesnt listen to his wife. Sloppy kisses for you xxx Rita "John Hay" <j.haywithoutdot@crbsolutionsremoveallthis.co.uk> wrote in message news:D70F2C8A-0F3B-4EE6-9B30-F9FE80C73B77@news.elevatesoft.com... > Rita >> The following code is ok for one day >> how can i make it work for everyday. >> So i dont have to change the day eachtime. >> >> ############################################### >> UPDATE MYFILE >> SET DAY = 'Monday' >> WHERE EXTRACT(DAYOFWEEK FROM DATE) = 1 >> ############################################### > > How about > > UPDATE MyFile SET Day= > IF(EXTRACT(DAYOFWEEK FROM DATE) = 1 THEN 'Monday' ELSE > IF(EXTRACT(DAYOFWEEK FROM DATE) = 2 THEN 'Tuesday' ELSE > IF(EXTRACT(DAYOFWEEK FROM DATE) = 3THEN 'Wednesday' ELSE > IF(EXTRACT(DAYOFWEEK FROM DATE) = 4 THEN 'Thursday' ELSE > IF(EXTRACT(DAYOFWEEK FROM DATE) = 5 THEN 'Friday' ELSE > IF(EXTRACT(DAYOFWEEK FROM DATE) = 6 THEN 'Saturday' ELSE > 'Sunday')))))) > > John > >