CodingForums.com - View Single Post

Fou-Lu · 10-15-2012, 10:25 PM

DBMS are far from my strong point especially oracle. But I'm not familiar with the DATEPART function. The error indicates that oracle isn't either (maybe a pl/sql specific?). I always use EXTRACT when I need to pull something out of Oracle by year:

Code:

EXTRACT(YEAR from tbl.DateField) = 2012

Looks like it'll do it.

10-15-2012, 10:25 PM	PM User \| #2
Fou-Lu God Emperor Join Date: Sep 2002 Location: Saskatoon, Saskatchewan Posts: 15,640 Thanks: 4 Thanked 2,448 Times in 2,417 Posts	DBMS are far from my strong point especially oracle. But I'm not familiar with the DATEPART function. The error indicates that oracle isn't either (maybe a pl/sql specific?). I always use EXTRACT when I need to pull something out of Oracle by year: Code: EXTRACT(YEAR from tbl.DateField) = 2012 Looks like it'll do it.