Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM SQL » View Thread |
Messages 1 to 7 of 7 total |
update |
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 > > |
This web page was last updated on Saturday, May 4, 2024 at 12:54 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |