# Convert Date to Time

**URL:** <https://www.ruby-forum.com/t/convert-date-to-time/54313>\
**Category:** Rails\
**Created:** [March 1, 2006, 11:43am UTC](https://www.ruby-forum.com/t/convert-date-to-time/54313 "2006-03-01T11:43:54Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![chris](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/958977/32.png) [@chris](https://www.ruby-forum.com/u/chris)\
**Post date:** [March 1, 2006, 11:43am UTC](https://www.ruby-forum.com/t/convert-date-to-time/54313/1 "2006-03-01T11:43:54Z")

</div>

Hi,

How do i convert a Date to a Time??

I have a date returned from sql and i need to be able to use handy  
functions like next\_week or beggining of week.

Any help appreciated  
Thanks,  
Chris

---

<div class="post-metadata">

**Author:** ![chris](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/958977/32.png) [@chris](https://www.ruby-forum.com/u/chris)\
**Post date:** [March 1, 2006, 12:08pm UTC](https://www.ruby-forum.com/t/convert-date-to-time/54313/2 "2006-03-01T12:08:17Z")

</div>

Hi,

sql\_date = “2006-03-01 11:59:01”

var = Time.local(\*ParseDate.parsedate(sql\_date))  
var.next\_week

Cheers!

Mathias Stjernstrom

---

<div class="post-metadata">

**Author:** ![chris](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/958977/32.png) [@chris](https://www.ruby-forum.com/u/chris)\
**Post date:** [March 1, 2006, 1:46pm UTC](https://www.ruby-forum.com/t/convert-date-to-time/54313/3 "2006-03-01T13:46:32Z")

</div>

Thanks Mathias!,

but what i was looking for is this :

a=Time.new  
d=a.to\_date()

AND

a=Date.new  
t=a.to\_time()

Chris

---

<div class="post-metadata">

**Author:** ![chris](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/c/958977/32.png) [@chris](https://www.ruby-forum.com/u/chris)\
**Post date:** [March 1, 2006, 2:00pm UTC](https://www.ruby-forum.com/t/convert-date-to-time/54313/4 "2006-03-01T14:00:38Z")

</div>

mb\>ruby script/console  
Loading development environment.

> > t = Time.new  
> > =\> Wed Mar 01 13:59:31 W. Europe Standard Time 2006  
> > d = t.to\_date  
> > =\> #\<Date: 4907591/2,0,2299161\>  
> > d.class  
> > =\> Date  
> > t = d.to\_time  
> > =\> Wed Mar 01 00:00:00 W. Europe Standard Time 2006  
> > t.class  
> > =\> Time

On Wednesday, March 01, 2006, at 1:46 PM, Chris wrote:

> t=a.to\_time()
> 
> Chris
> 
> –  
> Posted via [http://www.ruby-forum.com/](http://www.ruby-forum.com/).
> 
> * * *
> 
> Rails mailing list  
> removed\_email\_address@domain.invalid  
> [http://lists.rubyonrails.org/mailman/listinfo/rails](http://lists.rubyonrails.org/mailman/listinfo/rails)

Mikkel B.

www.strongside.dk - Football Portal(DK)  
[nflfeed.helenius.org](http://nflfeed.helenius.org) - Football News(DK)  
ting.minline.dk - Buy Old Stuff!(DK)