Anonymous
Not applicable

There is a built in function current_timestamp() that you can cast as a date and that should be very close to what you're looking for.