CONVERT(VARCHAR(7), dateadd(s, petty_cashes.effective_date, '1970/01/01') AT TIME ZONE 'Asia/Colombo'), 120)
SELECT [petty_cashes].[effective_date] AT TIME ZONE 'UTC' AS EffectiveDate FROM [account_codes] INNER JOIN [petty_cashes] ON [petty_cashes].[id] = [account_codes].[petty_cash_id] AND...