0

This is my query

SELECT 
from_unixtime(dispo_epoch,'Africa/Johannesburg') 
FROM "analytics"."table1"
WHERE lead_id = 100000

Result returned is: 2020-03-31 12:37:43.000 Africa/Johannesburg

Result I want should be : 2020-03-31 12:37:43 without the milliseconds and timezone string

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.