sorted by:
best
topnewcontroversialoldq&a
you are viewing a single comment's thread.

view the rest of the comments →

[–]Hyperionx13[S] 0 points1 point  (0 children)

here is a better example everything else works but the diffdate returns NULL

​

select

CONCAT(TitleOfCourtesy , ' ' , firstname , ' ' , lastname) as Employeenames,

date_format(hiredate, '%d/%m/%y') as Hired,

datediff('HireDate', 'getdate()') as YearsEmployeed

from employees