Oopss.. Sorry, I refer to the previous version then. Yes it is correct, the SQL is in the header files for SVN/latest version. Thanks for your correction Rene.
On Feb 24, 2012, at 11:18 PM, Rene Kluwen wrote: > I think the SQL statements are gathered in the header files, not the source > files. > > So for the mysql engine, you need sqlbox_mysql.h and then in particular the > line that says SQLBOX_MYSQL_INSERT_QUERY. > > == Rene > > -----Original Message----- > From: users-boun...@kannel.org [mailto:users-boun...@kannel.org] On Behalf > Of Willy Mularto > Sent: Friday, 24 February, 2012 09:56 > To: Knut Olafson > Cc: users@kannel.org > Subject: Re: Using SQLBOX - unix timestamp > > 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) > > > > > > > > > > > > Willy Mularto F300HD+MR18DE (NLC1725)
