Extract month name and year from timestamp to same column

Solution 1:

Example for you:

select 
    TO_CHAR(created_at, 'Month') AS "Month", 
    TO_CHAR(created_at, 'YYYY') AS "Year", 
    trim(TO_CHAR(created_at, 'Month')) || ', ' || trim(TO_CHAR(created_at, 'yyyy')) as mydate   
from acc_facts

Result data:

January     2022    January, 2022
January     2022    January, 2022
May         2022    May, 2022
March       2022    March, 2022

how to filter collection docs based on another collection?

Laravel: file_put_contents() permission denied — correct storage/framework/cache permissions?

Flutter desktop app for MacOS using extra binaries crashes when exported

Python | Netmiko | Auto ping

Next.js doesn't return slug with useRouter in console log

First order logic: if A sentence is satisfiable then it is satisfiable in the natural number + even function

Examples of incomplete normed spaces of continuous linear maps between two normed spaces [duplicate]

Is $\sum_{j=1}^\infty\sum_{n=1}^\infty\left(\frac{e^{-j/n}}{n^2}-\frac{e^{-n/j}}{j^2}\right)=\gamma ?$

Find $\lim_{n\to\infty}x_n=(\frac{5\sum_{k=1}^nk^4}{n^5})^n$

Simple question about finitely generated algebras

Prove the existence and uniqueness of a global minimum for a quadratic function $q(x)$ with positive definite Hessian

What is the correct standard deviation when splitting a sample?

Extract month name and year from timestamp to same column

Solution 1:

Related

Recent Posts