U++ framework: U++ SQL » Select a month in SQL

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

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

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

Fri, 15 October 2010 14:37

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

[Message index]

		Select a month in SQL By: koldo on Fri, 15 October 2010 10:01
		Re: Select a month in SQL By: sergeynikitin on Fri, 15 October 2010 13:34
		Re: Select a month in SQL By: mirek on Fri, 15 October 2010 14:37
		Re: Select a month in SQL By: koldo on Fri, 15 October 2010 23:07
		Re: Select a month in SQL By: sergeynikitin on Sat, 16 October 2010 00:03

Previous Topic:	Sqlite: Missing GetTransactionLevel() Method - Implemented
Next Topic:	Missing ASSERT?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun May 24 16:38:52 GMT+2 2026

Total time taken to generate the page: 0.00439 seconds