User Profile

Collapse

Profile Sidebar

Collapse
breimer
breimer
Last Activity: Feb 25 '08, 03:44 PM
Joined: Feb 22 '08
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • breimer
    replied to Updating day portion od date field
    in DB2
    Results are great! I'll play with the calculation to see if I can get either 1 or 21 as the final day values. Greatly appreciate your assistance..... bill...
    See more | Go to post

      Leave a comment:

    • breimer
      started a topic Updating day portion od date field
      in DB2

      Updating day portion od date field

      I have created a simple database with a single date field & inserted the current date. What I need to do is alter the day portion of this date field to be a value of 01 if the day of the current month is less than 21, otherwise the value should be 20. Thanks..bill

      Here's a sample of the code I am attempting to use:
      Code:
      code=DB2
-- drop date table
drop table REIMEB2.DATE_TABLE;
-- create date table
      ...
      See more | Go to post
      Last edited by docdiesel; Feb 23 '08, 09:38 PM. Reason: Added code tags
      No activity results to display
      Show More
      Working...