Community,
I have a SQL column RECEIPT_INFO_CFV.ARRIVAL_DATE which is showing like below,
8/15/2022 5:14:12 PM
which function I can use in SQL to retrieve Month in a column, and Year in a column, for above sample, SQL result should return like below,
Month Year
8 2022
Thank you.
Best answer by dsj
Hi
You can use following syntax to get month and year
select to_char(ARRIVAL_DATE , 'MM') Month,to_char(ARRIVAL_DATE , 'YYYY') Year from RECEIPT_INFO_CFV
Hope it helps!
Damith
+22Hi
You can use following syntax to get month and year
select to_char(ARRIVAL_DATE , 'MM') Month,to_char(ARRIVAL_DATE , 'YYYY') Year from RECEIPT_INFO_CFV
Hope it helps!
Damith
+13Hi
Try EXTRACT function. see the example.
SELECT
EXTRACT(MONTH FROM ARRIVAL_DATE) AS month,
EXTRACT(YEAR FROM ARRIVAL_DATE) AS year
FROM RECEIPT_INFO_CFV;
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.