i want to get only year value from a datetime field

select datepart(yy,getdate())

--or--

select year(getdate())

select YEAR(ageData) as year from Appointments;

Hi Ramon,

I got the idea from w3schools.com, You can definately try this one.

SELECT EXTRACT(YEAR FROM "2020-12-29 20:44:06.653 UTC") as Year;

Hey,

Please try this one,

or you can try datapart function.

I mean, from creation_date field i only want the year not the complete value:

What SQL command do i can use??

Hi Ramon,

Year can achieve in two way

1) Call var d = dateObject.getFullYear() method on date object.

2) Split the date object with var d =dateObject.split("-") and year will get it d[0];

Hope it will help you.