The SQL command to create this view and do the conversion would look like this: CREATE VIEW YOURSCHEMA.WORKAROUNDVIEW as select … , CONVERT ( TIMESTAMP , TSLTZ) AS DTCONVERTED from YOURSCHEMA.