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: 3360
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

[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: Mon May 06 04:53:22 CEST 2024

Total time taken to generate the page: 0.01968 seconds