CODEWITHSUNDEEP
javadateorientdbjbake
Riduidel
Riduidel

Reputation: 22300

How to get only year from a date stored in OrientDB

I'm working on JBake, and would like to get the year part of the date at which a document was stored.

I know I can get the date by doing

SELECT date FROM post

And OrientDB will return me a java.util.Date.

I know I can also add the year as another field, but I find this data duplication unsatistfying.

So, is it possible to store the date, and to to have the year extracted through some kind of SQL "function" ?

Typically I would love to do

SELECT date, {date.getYear()} FROM post

Upvotes: 2

Views: 754

Answers (1)

wolf4ood
wolf4ood

Reputation: 1949

You could use the format() function using the SimpleDateFormat syntax:

select date.format('YYYY') from post

Upvotes: 3

Related Questions