How to get the date as per the database


#1

I facing a issue like subscrition of the product get expires on “Nov 30 2018 23:59:59”
but in the report i am getting like “Dec 1 2018 5:30 AM”
even though i have selected the Asia/Culcutta as my report time zone


#2

This is what i am getting in the backend
SQLException:
Message: Unknown or incorrect time zone: ‘Asia/Calcutta’
SQLState: HY000
Error Code: 1298