# Postgresql timeStamp and ruby Time.now?

**URL:** <https://www.ruby-forum.com/t/postgresql-timestamp-and-ruby-time-now/84820>\
**Category:** Rails\
**Created:** [February 7, 2007, 11:28pm UTC](https://www.ruby-forum.com/t/postgresql-timestamp-and-ruby-time-now/84820 "2007-02-07T23:28:11Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![sayoyo](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ba8739/32.png) [@sayoyo](https://www.ruby-forum.com/u/sayoyo)\
**Post date:** [February 7, 2007, 11:28pm UTC](https://www.ruby-forum.com/t/postgresql-timestamp-and-ruby-time-now/84820/1 "2007-02-07T23:28:11Z")

</div>

Hi,

I have a postgresql DB table which has “timeStamp” field, I wonder if it  
is a good way to store time with ruby-rails “Time.now” with a  
“timeStamp” field??? or will it better to store the “Time.now” into a  
“varchar” or “text”???

does anyone have an idea?

Thanks you very much

Sayoyo

---

<div class="post-metadata">

**Author:** ![sayoyo](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ba8739/32.png) [@sayoyo](https://www.ruby-forum.com/u/sayoyo)\
**Post date:** [February 7, 2007, 11:30pm UTC](https://www.ruby-forum.com/t/postgresql-timestamp-and-ruby-time-now/84820/2 "2007-02-07T23:30:42Z")

</div>

I vote timestamp if you ever want to alter it. but varchar if it is read  
only

---

<div class="post-metadata">

**Author:** ![sayoyo](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ba8739/32.png) [@sayoyo](https://www.ruby-forum.com/u/sayoyo)\
**Post date:** [February 8, 2007, 9:02am UTC](https://www.ruby-forum.com/t/postgresql-timestamp-and-ruby-time-now/84820/3 "2007-02-08T09:02:35Z")

</div>

I use timestamp column type. Also, if you name your columns as  
created\_on and updated\_on you don’t have to populate it, Rails will do  
it automatically for you.

---

<div class="post-metadata">

**Author:** ![sayoyo](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/s/ba8739/32.png) [@sayoyo](https://www.ruby-forum.com/u/sayoyo)\
**Post date:** [February 8, 2007, 3:59pm UTC](https://www.ruby-forum.com/t/postgresql-timestamp-and-ruby-time-now/84820/4 "2007-02-08T15:59:15Z")

</div>

I will definitively use timeStamp:)

Thanks you very much for the information!!!

sayoyo

Ahmad wrote:

> I use timestamp column type. Also, if you name your columns as  
> created\_on and updated\_on you don’t have to populate it, Rails will do  
> it automatically for you.