0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for Tridion developers and administrators

SELECT 
  id, 
  YEAR(creationdate) AS creation_year, 
  MONTH(creationdate) AS creation_month, 
  DAY(creationdate) AS creation_day,
  tags 
FROM 
  posts 
WHERE 
 year(creationdate) = '2024' and posttypeid =1 ;

fork query

edited nov 24

created nov 24 jon.doe46369