# Select year from database as datetime

**URL:** <https://www.ruby-forum.com/t/select-year-from-database-as-datetime/100066>\
**Category:** Ruby\
**Created:** [February 1, 2006, 11:55pm UTC](https://www.ruby-forum.com/t/select-year-from-database-as-datetime/100066 "2006-02-01T23:55:42Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![misiek](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/76d3ee/32.png) [@misiek](https://www.ruby-forum.com/u/misiek)\
**Post date:** [February 1, 2006, 11:55pm UTC](https://www.ruby-forum.com/t/select-year-from-database-as-datetime/100066/1 "2006-02-01T23:55:42Z")

</div>

I got in database datetime field  
I need to pick all data from database where date is this year  
sample

database datetime a  
2006-01-30 00:00:00 this date is this year 2006  
2005-01-30 00:00:00 is not

sample

year = 2006  
time\_in -\> looks now like that 2006-01-30 00:00:00

@hours = Hour.find(:all, :conditions =\> " time\_in = " + year )

so I need do like : time\_in.year = year  
heh but it does not work of course

any one please …??

---

<div class="post-metadata">

**Author:** ![misiek](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/m/76d3ee/32.png) [@misiek](https://www.ruby-forum.com/u/misiek)\
**Post date:** [February 2, 2006, 12:17am UTC](https://www.ruby-forum.com/t/select-year-from-database-as-datetime/100066/2 "2006-02-02T00:17:15Z")

</div>

misiek wrote:

> year = 2006  
> time\_in -\> looks now like that 2006-01-30 00:00:00
> 
> @hours = Hour.find(:all, :conditions =\> " time\_in = " + year )
> 
> so I need do like : time\_in.year = year  
> heh but it does not work of course
> 
> any one please …??

I assume this is an ActiveRecord / Rails issue. I cannot comment on the  
details of that but from a DB background you need a range query.

select …  
from …  
where time\_in \>= ‘2006-01-01 00:00:00’ and time\_in \< ‘2007-01-01  
00:00:00’

You can as well use “between”. HTH

Kind regards

```
robert
```