Page 1 of 1

profile date field does not save time

Posted: Mon May 12, 2008 11:22 pm
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.