What does the Default Function column do when creating a new table?

Can it be used to default the value to today's date? Ultimately I would like the value in the field to default to the current month - is that possible?