The difference between different date/time formats in ActiveRecord has little to do with Rails and everything to do with whatever database you're using. Using MySQL as an example (if for no other reason because it's most popular), you have DATE, DATETIME, TIME and TIMESTAMP column data types; just as you have CHAR, VARCHAR, FLOAT and INTEGER. So, you ask, what's the difference? Well, some of them