dboyd13

# Purpose:
# SELECT: All DRINKS of a specific Keg
# OUTPUT: Drink ID, Day of Week, Date and time (localtime), 
# SORTED BY: Volume_ml

select id, substr('SunMonTueWedThuFriSat', 1 + 3*strftime('%w', datetime(time, "localtime")), 3), datetime(time, "localtime"), volume_ml from core_drink where keg_id=61 ORDER BY volume_ml;

# Purpose:
# SELECT: All DRINKS of a specific Keg ONLY if weekday (Mon-Fri)
# OUTPUT: Drink ID, Day of Week, Date and time (localtime)

dboyd13

    ___      _____          ___         _   _  __ _        _   ___                  _ _          ___              _      _ _        
   /_\ \    / / __|  ___   / __|___ _ _| |_(_)/ _(_)___ __| | / __| ___ __ _  _ _ _(_) |_ _  _  / __|_ __  ___ __(_)__ _| | |_ _  _ 
  / _ \ \/\/ /\__ \ |___| | (__/ -_) '_|  _| |  _| / -_) _` | \__ \/ -_) _| || | '_| |  _| || | \__ \ '_ \/ -_) _| / _` | |  _| || |
 /_/ \_\_/\_/ |___/        \___\___|_|  \__|_|_| |_\___\__,_| |___/\___\__|\_,_|_| |_|\__|\_, | |___/ .__/\___\__|_\__,_|_|\__|\_, |
                                                                                          |__/      |_|                        |__/
                                                                                          
Notes taken in Mar-2018, from acloud.guru and AWS FAQ

  ___                  _ _          _  __  _ 
 / __| ___ __ _  _ _ _(_) |_ _  _  / |/  \/ |

dboyd13

For a Micronta (Model: 63-7008). Adjust the date/time as follows:

1) Press and HOLD the 'C / mode' button (bottom right) until 'AL' appears.
2) Press the 'C / mode' button again (Short press)
3) You are now in the set time mode. Move positions by pressing 'X', adjust position value by pressing '-' (minus)
4) Once you've set the time, Move to the calendar positions using the same 'X' key
5) Once complete, press the 'C / mode' button to return to the standard time display.