This question has been flagged
1 Reply
2395 Views

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
Discard
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
Discard
Author

so how can i change utc time zone to postgresql