Try to put single quote inside single code

Scriptcase 9 General
#1

Hoew can i make it work date_trunc("’“hour”’", public.pong8_maintable.“timestamp8”) as Date_hour, , This sql I test It work (SELECT
public.pong8_maintable.stockid,
public.pong8_maintable.filname,

date_trunc(‘hour’, public.pong8_maintable.“timestamp8”) as Date_hour,

public.pong8_maintable.“Turnover”
FROM
public.pong8_maintable )


$sql ='

CREATE TABLE pong8_StepOneSection as
SELECT
public.pong8_maintable.stockid,
public.pong8_maintable.filname,

date_trunc("'"hour"'", public.pong8_maintable."timestamp8") as Date_hour,

,
public.pong8_maintable."Turnover"
FROM
Public.pong8_maintable

' ;
    



sc_exec_sql($sql);
#2

date_trunc(‘hour’, public.pong8_maintable.“timestamp8”) as Date_hour, I try this one work