Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

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

vardan10's profile image vardan10 posted 3 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 3 years ago Permalink

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

siya's profile image siya posted 3 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/

Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.
lukinhaspm's profile image lukinhaspm posted 3 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

Dharmatj63@gmail.com's profile image Dharmatj63@gmail.com posted 3 years ago Permalink

want more info

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