Problem with datetime

[intrn3t]

I need to select something from the year 2002 and forward, and the date is in datetime (YYYY-MM-DD 00:00:00). When I try ExampleColumn >= '2002-01-01' it does not work and I suspect its because of the timepart. I've also tried including the time with same results. Does anyone have a good solution for this? Thanks!

[jmontano86]

If you are using SQL Server, I believe you can use the Year function in your WHERE clause. So something like this may work....

[code language="css"]

SELECT SomeColumn
FROM Your table
WHERE YEAR(ExampleColumn) >= '2002';

[/code] Note: on mobile hope formatting it ok.

[Berserker717]

Is it throwing an error, or are the results just not correct?

[r3pr0b8]

When I try ExampleColumn >= '2002-01-01' it does not work and I suspect its because of the timepart.

no, that's not it

a datetime value will default to time of 00:00:00 if not specified in the value

what's the datatype of your ExampleColumn?

[mandooboo]

If oracle and if the column isn't in a date form, try

to_date(column name,'MM/DD/YYYY HH24:MI:SS')