Hi,
Please consult the online Mysql reference. This is not a kannel question. If
you use varchar or even datetime type column column, you better provide the
value yourself. If you use timestamp type column, you can have mysql
initialize it to current time.
BR,
Nikos
----- Original Message -----
From: brett skinner
To: [email protected]
Sent: Tuesday, June 29, 2010 12:12 PM
Subject: Datatype for timestamp for mysql dlr storage
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,
