Help for separating time

Rails
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

Brijesh S. wrote:

just remove :time option from the syntax…

thanks for the reply…
actually i need time and date aswell .
but i want to split the date and time …
how can i do it

September 30, 2009 03:08 PM

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 N. wrote:

Brijesh S. wrote:

just remove :time option from the syntax…

thanks for the reply…
actually i need time and date aswell .
but i want to split the date and time …
how can i do it

September 30, 2009 03:08 PM

5

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…

6

Hi Colin

Conversion is required because passing value is string not datetime …

7

Brijesh S. wrote:

Hi Colin

Conversion is required because passing value is string not datetime …

thank you guys…
and thanks to Brijesh S…
it works now

8

2009/9/30 Brijesh S. [email protected]:

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

9

Colin L. wrote:

2009/9/30 Brijesh S. [email protected]:

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

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.

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

pls suggest me

10

2009/9/30 Brijesh S. [email protected]:

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

11

Newb N. 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
[email protected]

12

Marnen Laibow-Koser wrote:

Newb N. 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
[email protected]

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

13

Use TIME_FORMAT in mysql query to fetch records…

SELECT * FROM TABLE_NAME
WHERE TIME_FORMAT( time, “%h:%i %p” ) > “12:00 am”
AND TIME_FORMAT( time, “%h:%i %p” ) < “7:00 pm”

Set the format as per your requirement…

http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_time-format

14

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

On Sep 30, 7:02 am, Newb N. [email protected]