#
Common Data Types
#
Money
Monetary values should be stored and operated on in application code as a Decimal type. Transmission of monetary values to frontend should also be sent as decimal. Frontend is responsible for conversion to currency friendly display.
#
Dates
Store dates as UTC time, transmit in ISO8601 format, convert to local time is client side responsibility
Doesn't HAVE to be UTC for legacy, but must be for new "stuff" - don't be a weasel