how to use timestamptz
Whenever I am entering a new row in my database it is showing in UTC but I want in Indian standard time IST +5:30
So I tried to use timestamptz but stuck at its default value
(now() AT TIME ZONE 'utc'::text)
I tried to replace the UTC with IST but no use I am still getting UTC time in my row
So I tried to use timestamptz but stuck at its default value
(now() AT TIME ZONE 'utc'::text)
I tried to replace the UTC with IST but no use I am still getting UTC time in my row