gistfile1.txt

SELECT 
  date_column,
  CASE 
    WHEN EXTRACT(DAYOFWEEK FROM date_column) = 7 THEN DATE_ADD(date_column, INTERVAL 2 DAY)  -- Saturday to Monday
    WHEN EXTRACT(DAYOFWEEK FROM date_column) = 1 THEN DATE_ADD(date_column, INTERVAL 1 DAY)  -- Sunday to Monday
    ELSE date_column  -- Keep the date as is if it's not Saturday or Sunday
  END AS adjusted_date
FROM your_table;