HELP FOR SEPARATING TIME

rubyonrails-talk
1

hi.. i m using date picker like below <%= calendar_date_select_tag "e_date", Date.today, :popup => :force ,:time => true %>

when i submit the form i get parameter like below

September 30, 2009 03:08 PM

i want to cut the time from it...

tat is 03:08 PM and September 30, 2009 has to be separated..

any helps for this...

Thanks for taking time to help

2

just remove :time option from the syntax..

3

You can separate date and time by...

first you need to convert into date format datetime=params[:e_date] datetime=datetime.to_date date = date.strftime('%Y-%m-%d')"

I hope this helps u...

4

Hi Newb newb

use @date.strftime("%B %d, %Y")

to display only date no time. and in table insert September 30, 2009 03:08 PM

Newb Newb wrote:

5

You can separate date and time by...

first you need to convert into date format datetime=params[:e_date] datetime=datetime.to_date

I think there is no need to convert it to a Date, just use strftime on the DateTime object to show just the date portion.

Colin

6

Hi Colin

Conversion is required because passing value is string not datetime ...

7

Yes you are right, I was thinking datetime_select was being used to read into a DateTime object.

Colin

8

Newb Newb wrote: [...]

hi all.. i want to ask one more help...

d0_time = d0.strftime("%I:%M %p") d1_time = d1.strftime("%I:%M %p")

12:00 am 07:00 pm i get two times here.i ll take the above times as from and to. i have time as field into my table.it stores like 01:17:56 am.

Are you storing the time as a string in the DB? If so, don't. Store times as time or datetime.

i want to fetch the records which is between the above two times .. how can i implement the query

SELECT * FROM table WHERE hour(time) BETWEEN 0 and 19

pls suggest me

Best,

9

Marnen Laibow-Koser wrote:

Newb Newb wrote: [...]

hi all.. i want to ask one more help...

d0_time = d0.strftime("%I:%M %p") d1_time = d1.strftime("%I:%M %p")

12:00 am 07:00 pm i get two times here.i ll take the above times as from and to. i have time as field into my table.it stores like 01:17:56 am.

Are you storing the time as a string in the DB? If so, don't. Store times as time or datetime.

i want to fetch the records which is between the above two times .. how can i implement the query

SELECT * FROM table WHERE hour(time) BETWEEN 0 and 19

pls suggest me

Best, -- Marnen Laibow-Koser http://www.marnen.org marnen@marnen.org

hi.. i m using date picker like below <%= calendar_date_select_tag "e_date", Date.today, :popup => :force ,:time => true %>

is it possible to disable the dates ... i want to able to select only time... is it possible... thanks in advance

10

Model.find(:all, :conditions => {:time_field => (from..to)})