Hi there, I have the same problem. I would like to have datetime in readable format in db instead of timestamp. Reading this I have changed that column in db from bigint(20) to datetime and now, have something like this (for all entries): 0000-00-00 00:00:00 How to resolve this ?? Thanks. A.
Willy Mularto-2 wrote: > > change the type to datetime ;) > > > On Mar 21, 2011, at 5:47 PM, ha...@aeon.pk wrote: > >> Hi, >> >> While using sqlbox, the column 'time' in sent_sms column of kannel >> database is having timestamp values in unix time. Is there a parameter in >> config by which I could control it to paste values in normal timestamps >> in the table? >> >> Thanks, >> H > > Willy Mularto > F300HD+MR18DE (NLC1725) > > > > > > > > > > -- View this message in context: http://old.nabble.com/Using-SQLBOX---unix-timestamp-tp31199396p33383570.html Sent from the Kannel - User mailing list archive at Nabble.com.
