Skip to Content
This question has been flagged
timezone
1 Odpoveď
3020 Zobrazenia
Avatar
Ashish Singh

Hello Guys

in my application i had set time zone -Asia/Kolkata

when i click on sign in button for attendence its displaying date & time like 06/14/2014 18:19:02 but in my database its display 06/14/2014 12:49:02

 

I want to know why its displaying like that,mean there is some differenc b/w time

 

Please help me

Thanks

Avatar
Zrušiť
Avatar
Antonio M. Vigliotti
Best Answer

I guess, your database ha UTC timestamp. UTC is the same timezone of GMT but without summertime.

------------

I think it is no a really mismatch.

 

Server applications use internal UTC datetime in order to avoid error when time changes form standard time to summertime and usign UTC they can exchange timed info across internet (i.e. crypted keys).

Users instead use local time.

You have to remember differential time.

 

Avatar
Zrušiť
Ashish Singh
Autor

so how can i change utc time zone to postgresql

Related Posts Replies Zobrazenia Aktivita
Time zone problem in python
timezone
Avatar
Avatar
2
apr 23
3329
How to change the time Zone in openerp?
timezone
Avatar
Avatar
Avatar
2
feb 21
16493
Time in Scheduled Action not matching time based on User Preferences Timezone
timezone
Avatar
1
okt 20
3526
Error on TimeZone Field Solved
timezone
Avatar
Avatar
Avatar
2
aug 19
3875
Is the javascript code in Odoo project which convert the localtime into UTC and vice versa? (Ver 9)
timezone
Avatar
0
sep 16
4465