Databases
StackOverflow2013
Postsdbo
POUTC time resets to 2000-01-01 (ruby). How do I prevent the time from resetting?
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POUTC time resets to 2000-01-01 (ruby). How do I prevent the time from resetting?
    primarykey
    data
    text
    <p>I'm using a task and the spreadsheet gem to read in an excel spreadsheet into my database. One of the columns I'm reading in is "start_time." To do this, I'm forming an array of values, then passing in each of these array values, one by one. </p> <pre><code> cnum_array = [] # for start times sheet1.each 3 do |row| unless row[9].blank? time = Time.parse(row[9]) cnum_array &lt;&lt; time.utc end end count = 0 for course in Course.all course.update_attribute :start_time, cnum_array[count] count += 1 end </code></pre> <p>This seems to work fine. If I insert a "puts course.start_time" statement within this last loop, it prints off the right time. Like so: </p> <pre><code> count = 0 for course in Course.all course.update_attribute :start_time, cnum_array[count] puts course.start_time count += 1 end </code></pre> <p>This gives me the right time, e.g. "2012-01-23 15:30:00."</p> <p>But when I look up the course time later (e.g. via my console's Course.find(1).start_time), it gives me "2000-01-01 15:20:00." So the time of day is right, but the day itself goes back to 2000-01-01. </p> <p>Does anyone know why this is happening, and how I can fix it? Thanks! </p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. This table or related slice is empty.
    1. USjyli7
    plurals
    1. This table or related slice is empty.
    1. PL
      singulars
      1. LTLinked
    2. PL
      singulars
      1. LTDuplicate
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POUTC time resets to 2000-01-01 (ruby). How do I prevent the time from resetting?
      1. This table or related slice is empty.
      1. VTUpMod
    1. This table or related slice is empty.
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload