U++ forum: Welcome to the forum

Search on this site

Search in forums

Home » U++ Library support » U++ SQL » Select a month in SQL

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Select a month in SQL [message #29311]

Fri, 15 October 2010 10:01

koldo
Messages: 3437
Registered: August 2008

Senior Veteran

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);

Best regards
Iñaki

Report message to a moderator

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

Fri, 15 October 2010 13:34

sergeynikitin
Messages: 748
Registered: January 2008
Location: Moscow, Russia

Contributor

What type of SQL server?

SergeyNikitin<U++>( linux, wine )
{
under( Ubuntu || Debian || Raspbian );
}

Report message to a moderator

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

Fri, 15 October 2010 14:37

mirek
Messages: 14265
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