Get FIRST_NAME ,Joining year,Joining Month and Joining Date from employee table

hello all i am building a small project and i am stuck here

pls suggest me something stuff and things

thanks in advance

Provide some more information what you need, like tables, structure, data...

Select FIRST_NAME, to_char(joining_date,'YYYY') JoinYear , to_char(joining_date,'Mon'), to_char(joining_date,'dd') from EMPLOYEE

https://intellipaat.com/tutorial/sql-tutorial/

Try this

Select FIRST_NAME, year(joining_date) JoinYear , month(joining_date), day(joining_date) from EMPLOYEE

tips: when you ask, put the script/tables etc put what kind off SQL you are using, SQL Server, MySQL, Oracle, Postgre...

See you

want more info

Thanks for sharing a useful info. I would also suggest Social Prachar for Data Science course with Real time experience