Correct. Current Time (timezone 0) is 15:40. You see 15:40 + 2 i.e. 17:40. You need to store the Timezone difference for the User and then 'add' it to the Time retrieved.
I think you need to be clear about what you are doing and what information you need to store along with the Time... Unfortunately it's a little more complicated than just adding timezones.
i.e. time is stored (timezone 0?) or possibly timezone with a local timezone and then displayed with a remote timezone to take in to account.. Without more information about what you're trying to achieve it's a bit hard to help.
If they are 17:32
I think you should record in the database: 17:32
But save 15:32
2 hours ahead of GMT
Let me explain:
Madrid, GMT +2
It's 17:00 local time.
In the database, when a record is saved, "CURRENT_TIMESTAMP" stores 15:00
What I can do to "CURRENT_TIMESTAMP" store 17:00?
It may well be that you need to look a little further in to sqlite I'm not sure if it can handle the timezone or you take the calculation out of the sql statement and then process it in B4A and then pump the value in to sqlite. It's not something I've had to consider.