Equivalent of DAY() function

TheMSsForum.com: The Microsoft Software Forum

Hi,
What is the equivalent of DAY(), MONTH(), YEAR() function of SQLServer in
SQLServerCE

Thanks in advance,
Catalin
Top

Re: Equivalent of DAY() function by Matt

Matt
Tue Feb 13 10:17:51 CST 2007

On 13 Feb, 15:17, "Catalin Lungu" <lungucatalincos...@yahoo.es> wrote:
> Hi,
> What is the equivalent of DAY(), MONTH(), YEAR() function of SQLServer in
> SQLServerCE
>
> Thanks in advance,
> Catalin

DAY('1/1/2003') is the same as DATEPART(DAY, '1/1/2003')
MONTH('1/1/2003') is the same as DATEPART(MONTH, '1/1/2003')
YEAR('1/1/2003') is the same as DATEPART(YEAR, '1/1/2003')

Also see: http://msdn2.microsoft.com/en-us/library/aa237922(SQL.80).aspx

Top