Re: value of timestamp

[Chronis N.]

You get %T from kannel in GMT, so, you have just to add the timezone difference when adding into your database.   Regards, CHRONIS N. ----- Original Message ----- From: Jyothi rao To: Chronis Nikos Sent: Wednesday, July 26, 2006 1:43 PM Subject: Re: value of timestamp thanks Chronis, but is there any way that i can changed the value of %T, so that i can get the timestamp from kannel. On 7/26/06, Chronis Nikos <[EMAIL PROTECTED]> wrote: Hello,   This is probably because the %T is GMT. I suggest you to do from your receiver.php INSERT ... timestamp = '".time()."'   Best Regards, CHRONIS N. ----- Original Message ----- From: Jyothi rao To: users@kannel.org Sent: Wednesday, July 26, 2006 9:33 AM Subject: value of timestamp hi all, I have my kannel set up working fine with gsm modem. I am able to receive and send sms. When an sms is received, I am getting the sms through post-url and storing the sms in my own psql database.   I am storing timestamp, sender, receiver and message. All are stored successfully, but the value of timestamp is wrong. the timestamp showed in smsbox.log is '2006-07-26 12:58:09'   -- correct one but the value got in the database is  '2006-07-26 07:22:54'. can anyone say, where i am going wrong ? post-url : http://hostname/receiver.php?sender=%p&receiver=%P&timestamp=%t&message=%a&epoch_time=%T&msg_id=%I thanks, Jyothi Rao -- Jyothi Rao