Test Fixtures - Oracle date

What is the proper way of setting a test fixture for a date field in
Oracle db? I've tried various
ways like switching the year and no luck.

My test fixture is:

  id: 1
  department_id: 1
  last_name: test1
  first_name: first1
  birth_date: 2004-01-26 00:00:00
  country_of_origin: Canada
  job_title: Programmer
  created_on: 2004-01-26 00:00:00
  created_by: testuser
  updated_on: testuser
  created_on: 2004-01-26 00:00:00
  user_id: testuser

I keep on getting ActiveRecord::StatementInvalid: OCIError: ORA-01841:
(full) year must be between -4713 and +9999, and not be 0....

This should work:

created_on: <%= Time.now.to_s(:db) %>

Thanks Nicholas. The reason why it didnt work for me was because a
typo. I have 2 created_on fields which conflicted.