Answer / megha

select
'Quarter to '||to_char((to_date('01/01/'||substr(Src,2), 'dd/mm/rrrr')),'rrrr') as "Target"
from table

Answer / ajit

select substr(src, 1,1 )||'uarter to '||to_char(to_date (substr(src, 2), 'rrrr'), 'yyyy') tgt
from <Table Name>

Answer / abhiraj

with data as (select 'Q10' as src from dual)
select
'Quarter to '||to_char((to_date('01/01/'||substr(Src,2), 'dd/mm/rrrr')),'rrrr') as "Target"
from data

Answer / aditya saxena @adi

select 'Quarter to '||to_char(to_date('01/01/'||substr(months,2),'dd/mm/rrrr'),'RRRR') AS Src_Tgt from (
select 'Q10' months from dual
union all
select 'Q90' from dual
union all
select 'Q80' from dual
union all
select 'Q74' from dual
)
;

Answer / manohar

select 'Quarter to' ||to_char(cast('1/1/'||substr(Src) as
char),'YYYY') from table

Is sql harder than python?

0 Answers  

how to calculate the difference between two dates? : Sql dba

0 Answers  

suppose we have a table in which 200 rows. i want to find 101 row ? what the query.... and how we find 4th and 5th highest salary and 1 to 10 highest salary

7 Answers  

How do I save the results of sql query in a file?

0 Answers  

how to write date and time literals? : Sql dba

0 Answers  

what are the advantages and disadvantages of views in a database? : Sql dba

0 Answers  

What is difference between rank () row_number () and dense_rank () in sql?

0 Answers  

Describe different types of general function used in sql?

0 Answers  

How to execute a stored procedure?

0 Answers  

What are different types of indexes?

0 Answers  

How do you determine the current isolation level? : Transact sql

0 Answers  

Why truncate is used in sql?

0 Answers