U++ forum: Welcome to the forum

Re: Select a month in SQL [message #29330 is a reply to message #29311]

Fri, 15 October 2010 14:37

mirek
Messages: 13986
Registered: November 2005

Ultimate Member

koldo wrote on Fri, 15 October 2010 04:01

Hello all

A very simple question. How do you do to select all the registers of a month?

For example, this expression to select all people born in November, is not permitted:

SQL & ::Select(SqlAll()).From(TABLE)
			.Where(Month(BIRTHDATE) == 11);

Well, maybe it should have been permitted. But as this is rarely needed, nobody contributed the Month function yet.

Implementation will wildly vary based on database used, I am afraid.

Anyway, since then, you will have to look it up in your SQL reference and put into your U++ sql expression using generic SqlFunc. Then post it here so that we can start adding it to sqlexp (we in fact do NOT need all variants immediately).

Report message to a moderator