Hi

I am using the mysql dlr storage type. I have everything working except for
the timestamp. This is the output from debug mode

sql: INSERT INTO delivery_receipts (smsc, received, source, destination,
service, url, mask, boxc, status) VALUES ('XXXYYYXXX', '50062911024679487',
'+123123123', '+123123123', 'simple', '', '31', '', '0');

I set the delivery_receipts table received column to timestamp but when I
query it I get this 0000-00-00 00:00:00

What should the datatype of the received column be? I see in some places
people have left it as varchar. Is it up to me to do the translation.

Thanks and appreciate any assistance.

Regards,

Reply via email to