Equivalent of DAY() function

[Catalin Lungu]

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

Thanks in advance,
Catalin

 

[Matt Lacey]

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