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

[expired user #9934]'s profile image [expired user #9934] posted 8 years ago in Running SQL scripts Permalink

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

pls suggest me something stuff and things

thanks in advance

lukinhaspm's profile image lukinhaspm posted 8 years ago Permalink

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

[expired user #9937]'s profile image [expired user #9937] posted 8 years ago Permalink

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/

lukinhaspm's profile image lukinhaspm posted 8 years ago Permalink

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

[expired user #10656]'s profile image [expired user #10656] posted 7 years ago Permalink

want more info

ravidm43's profile image ravidm43 posted 3 years ago Permalink

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

Please login to leave a reply, or register at first.