profile date field does not save time

Use this forum to report bugs and to check for bugfixes and new releases of OpenEMM

Moderator: moderator

jhagstrand
Posts: 22
Joined: Thu Apr 17, 2008 8:38 pm

profile date field does not save time

Post by jhagstrand »

User-defined profile fields added to the customer table can be one of three types: Numeric, Alpha, or Date. The Date type is MySql type "Date" which does not include time. This prevents us from storing the time. When updating the customer table via web services using the addSubscriber method, you can specify the time on a date field, and it is ignored. If this column were type "timestamp" instead of "date" it would probably work.