Because it is fun to have more than one way to solve the same problem, you can also use EXTRACT to retrieve specific parts of a timestamp field:
select
Extract (Month
from ISSUE_DT) As “Month”
from
wc_asset_d
Because it is fun to have more than one way to solve the same problem, you can also use EXTRACT to retrieve specific parts of a timestamp field:
select
Extract (Month
from ISSUE_DT) As “Month”
from
wc_asset_d