at time zone
카테고리 없음 / 2023. 6. 23. 18:35
; with cte
as
(
select [timestamp] at time zone 'Korea Standard Time' kst, *
from t230614
)
select cast(duration / 1000. as int) milisec, *
from cte
where kst >= '2023-06-14 00:00:00.0000000 +09:00'
and statement like '%text%'
and name = 'sp_statement_completed'
order by kst
; with cte
as
(
select [timestamp] at time zone 'Korea Standard Time' kst, *
from t230614
)
select cast(duration / 1000. as int) milisec, *
from cte
where kst >= '2023-06-14 00:00:00.0000000 +09:00'