You need to do a little hack here. Go to SQLBox source code (gw/sqlbox_yourdb.c) and find the line where it injects the INSERT query, from here you must be able to figure it out (needs skill SQL)
On Feb 24, 2012, at 3:45 PM, Knut Olafson wrote: > > 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. > > Willy Mularto F300HD+MR18DE (NLC1725)
