HELP FOR SEPARATING TIME

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

just remove :time option from the syntax..

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...

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:

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

Hi Colin

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

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

Colin

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 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

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