# How to insert Current DateTime value into database?

**URL:** <https://www.ruby-forum.com/t/how-to-insert-current-datetime-value-into-database/93650>\
**Category:** Rails\
**Created:** [April 5, 2006, 3:24pm UTC](https://www.ruby-forum.com/t/how-to-insert-current-datetime-value-into-database/93650 "2006-04-05T15:24:48Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![tiwaripk](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/7ab992/32.png) [@tiwaripk](https://www.ruby-forum.com/u/tiwaripk)\
**Post date:** [April 5, 2006, 3:24pm UTC](https://www.ruby-forum.com/t/how-to-insert-current-datetime-value-into-database/93650/1 "2006-04-05T15:24:48Z")

</div>

Hi,

I want to insert onto database the Current DateTime Value into database  
field “Store\_date” with datatype (DATETIME). How to do tihs?

# I am usiing hidden variable into my form as follows:-

# \<%= hidden\_field(“store”, “store\_date”, :value =\>:datetime ) %\>

But when I m submmittng form I couldn’t find entry in store\_date field.

How to do this using hidden variable?

Please help me.  
Prashant

---

<div class="post-metadata">

**Author:** ![tiwaripk](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/t/7ab992/32.png) [@tiwaripk](https://www.ruby-forum.com/u/tiwaripk)\
**Post date:** [April 5, 2006, 4:09pm UTC](https://www.ruby-forum.com/t/how-to-insert-current-datetime-value-into-database/93650/2 "2006-04-05T16:09:39Z")

</div>

Prashant T. wrote:

> Hi,
> 
> I want to insert onto database the Current DateTime Value into database  
> field “Store\_date” with datatype (DATETIME). How to do tihs?
> 
> # I am usiing hidden variable into my form as follows:-
> 
> # \<%= hidden\_field(“store”, “store\_date”, :value =\>:datetime ) %\>
> 
> But when I m submmittng form I couldn’t find entry in store\_date field.
> 
> How to do this using hidden variable?
> 
> Please help me.  
> Prashant

Prashant, please look at the documentation regarding created\_on and  
updated\_on. There’ is no need to use a hidden field for thuis as rails  
will automatically update certion fields for you.

See, for example,  
[http://wiki.rubyonrails.org/rails/pages/MagicFieldNames](http://wiki.rubyonrails.org/rails/pages/MagicFieldNames)

As regards the hidden field, a quick google for “ruby on rails  
hiden\_field documentation” returned this:

[http://railsmanual.org/module/ActionView%3A%3AHelpers%3A%3AFormHelper#hidden\_field](http://railsmanual.org/module/ActionView%3A%3AHelpers%3A%3AFormHelper#hidden_field)

It looks like you’re attempting to specify the data type (:datetime) in  
the value field. Is that correct ?

Alan