# How do you Convert a Time or Date to SQL formatted date?

**URL:** <https://www.ruby-forum.com/t/how-do-you-convert-a-time-or-date-to-sql-formatted-date/94627>\
**Category:** Rails\
**Created:** [May 9, 2006, 1:34pm UTC](https://www.ruby-forum.com/t/how-do-you-convert-a-time-or-date-to-sql-formatted-date/94627 "2006-05-09T13:34:36Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![crenner](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/278dde/32.png) [@crenner](https://www.ruby-forum.com/u/crenner)\
**Post date:** [May 9, 2006, 1:34pm UTC](https://www.ruby-forum.com/t/how-do-you-convert-a-time-or-date-to-sql-formatted-date/94627/1 "2006-05-09T13:34:36Z")

</div>

I am executing some arbitrary SQL in which i need to convert a date/time  
object into an sql formatted string. Is there a simple way to do this  
in rails?

Thanks  
Chris

---

<div class="post-metadata">

**Author:** ![crenner](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/278dde/32.png) [@crenner](https://www.ruby-forum.com/u/crenner)\
**Post date:** [May 9, 2006, 2:16pm UTC](https://www.ruby-forum.com/t/how-do-you-convert-a-time-or-date-to-sql-formatted-date/94627/2 "2006-05-09T14:16:52Z")

</div>

Hello Chris,

> I am executing some arbitrary SQL in which i need to convert a  
> date/time object into an sql formatted string. Is there a simple  
> way to do this in rails?

Try : my\_date.to\_s(:db)

РJean-Fran̤ois.

---

<div class="post-metadata">

**Author:** ![crenner](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/278dde/32.png) [@crenner](https://www.ruby-forum.com/u/crenner)\
**Post date:** [May 9, 2006, 7:22pm UTC](https://www.ruby-forum.com/t/how-do-you-convert-a-time-or-date-to-sql-formatted-date/94627/3 "2006-05-09T19:22:54Z")

</div>

Chris R. wrote:

> I am executing some arbitrary SQL in which i need to convert a date/time  
> object into an sql formatted string. Is there a simple way to do this  
> in rails?
> 
> Thanks  
> Chris

try to do this  
date\_you\_want =  
“’”+dateTimeVar[“year”]+’-’+dateTimeVar[“month”]+’-’+dateTimeVar[“day”]+"’"

and then use it in the sentence.