# \[rails\] :date o :datetime?

**URL:** <https://www.ruby-forum.com/t/rails-date-o-datetime/117290>\
**Category:** IT\
**Created:** [October 15, 2007, 6:33pm UTC](https://www.ruby-forum.com/t/rails-date-o-datetime/117290 "2007-10-15T18:33:57Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![stratboy](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/838e76/32.png) [@stratboy](https://www.ruby-forum.com/u/stratboy)\
**Post date:** [October 15, 2007, 6:33pm UTC](https://www.ruby-forum.com/t/rails-date-o-datetime/117290/1 "2007-10-15T18:33:57Z")

</div>

Salve! Ultima domanda del giorno, promesso, anche se in pochissimi sono  
riusciti ad affrontare le mie precedenti… 😉

Scusate, che differenza c’è fra :date e :datetime? Nel senso, quando  
dovrei scegliere l’uno e quando l’altro, nel definire il tipo di una  
colonna?

Premetto che uso sqlite3, che supporta entrambi.

---

<div class="post-metadata">

**Author:** ![stratboy](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/838e76/32.png) [@stratboy](https://www.ruby-forum.com/u/stratboy)\
**Post date:** [October 15, 2007, 6:57pm UTC](https://www.ruby-forum.com/t/rails-date-o-datetime/117290/2 "2007-10-15T18:57:09Z")

</div>

> Scusate, che differenza c’è fra :date e :datetime?

:date == la data  
:datetime == la data e l’ora

---

<div class="post-metadata">

**Author:** ![stratboy](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/838e76/32.png) [@stratboy](https://www.ruby-forum.com/u/stratboy)\
**Post date:** [October 15, 2007, 6:57pm UTC](https://www.ruby-forum.com/t/rails-date-o-datetime/117290/3 "2007-10-15T18:57:45Z")

</div>

Quando vuoi memorizzare solo una data usa date altrimenti datetime se  
vuoi memorizzare data e ora 🙂

Il giorno 15/ott/07, alle ore 18:33, Luca R. ha scritto:

---

<div class="post-metadata">

**Author:** ![stratboy](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/838e76/32.png) [@stratboy](https://www.ruby-forum.com/u/stratboy)\
**Post date:** [October 15, 2007, 7:20pm UTC](https://www.ruby-forum.com/t/rails-date-o-datetime/117290/4 "2007-10-15T19:20:34Z")

</div>

On Mon, 15 Oct 2007 18:33:57 +0200  
Luca R. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> Salve! Ultima domanda del giorno, promesso, anche se in pochissimi sono  
> riusciti ad affrontare le mie precedenti… 😉

“sono riusciti ad affrontare” o “hanno gentilmente risposto al-”? c’è una  
bella differenza…

> Scusate, che differenza c’è fra :date e :datetime? Nel senso, quando  
> dovrei scegliere l’uno e quando l’altro, nel definire il tipo di una  
> colonna?

come dice il nome stesso, :date contiene solo informazioni sulla data  
(giorno, mese, anno):

[http://www.ruby-doc.org/stdlib/libdoc/date/rdoc/classes/Date.html](http://www.ruby-doc.org/stdlib/libdoc/date/rdoc/classes/Date.html)

mentre :datetime contiene anche informazioni sull’ora:

[http://www.ruby-doc.org/stdlib/libdoc/date/rdoc/classes/DateTime.html](http://www.ruby-doc.org/stdlib/libdoc/date/rdoc/classes/DateTime.html)

–  
Aequam memento rebus in arduis servare mentem…

Mauro T. [http://www.tortonesi.com](http://www.tortonesi.com)

University of Ferrara - Dept. of Eng. [http://www.ing.unife.it](http://www.ing.unife.it)  
GNU Wget - HTTP/FTP file retrieval tool  
[Wget - GNU Project - Free Software Foundation](http://www.gnu.org/software/wget)  
Deep Space 6 - IPv6 for Linux [http://www.deepspace6.net](http://www.deepspace6.net)  
Ferrara Linux User Group [http://www.ferrara.linux.it](http://www.ferrara.linux.it)

---

<div class="post-metadata">

**Author:** ![stratboy](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/838e76/32.png) [@stratboy](https://www.ruby-forum.com/u/stratboy)\
**Post date:** [October 15, 2007, 6:59pm UTC](https://www.ruby-forum.com/t/rails-date-o-datetime/117290/5 "2007-10-15T18:59:09Z")

</div>

Wow… 😉

Grazie!!!