Year in the where clause

Question

I need to get only this year's publications. Here's my where clause:where pubdate = '2010'and it generates an error.  How can I set the criteria to get only this year's results?THansk,Jenn

BKBK · Accepted Answer

where pubdate = 2010orwhere pubdate = #year(now())#

Adam Cameron. · Answer

Ok, if your code errors... make sure to post the error. Also if you're posting SQL questions, make sure to post the datatype of the columns concerned. And the DB system you're using.

I suspect your column is a date or timestamp or something? If so, you cannot compare it to a string, you can only compare the same data types (on the whole... there are some exceptions there, but not relevant to your situation).

Also, if the date value is "2010-04-20" (ie: today), then it's not going to match "2010" is it: because those are two different things.

What you need to do is to consult your DB's docs, and find out if there's a function for extrsacting the year part of a date (in indeed your column is a date), so you can compare like-for-like. The function name and how it works will be specific to your DB system.

--

Adam

Sign up

To post, reply, or follow discussions, please sign in with your Adobe ID.

Sign in to Adobe Community

To post, reply, or follow discussions, please sign in with your Adobe ID.

Scanning file for viruses.

This file cannot be downloaded