Bharat, You can easily transform between unix timestamps and date formats using sql. Check "date and time functions" on the mysql documentation for more info.
Regards, Alejandro On 10/12/07, Bharat Yadav <[EMAIL PROTECTED]> wrote: > > Hi for all > i have a problem i am using sqlbox and working fine with their own db but > now i modified sqlbox for pulling sms from my logica based smpp server db > its pulling data and handing over to kannel push sms to SMSC's with SMPP > v3.4, sqlbox working fine but some compatibility remain usolved like time > format not in gmt or local its in UNIX time like 1192013673 but i need like > 20071012121500 (yyyymmddhhmmss) how can i do it? please help me > thanks > > -- > View this message in context: > http://www.nabble.com/Sqlbox-Time-Format-tf4611736.html#a13170005 > Sent from the Kannel - User mailing list archive at Nabble.com. > > > -- Alejandro Guerrieri Magicom http://www.magicom-bcn.net/ LinkedIn: http://www.linkedin.com/in/aguerrieri
