newb
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
newb
2
just remove :time option from the syntax…
newb
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
newb
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
newb
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…
newb
6
Hi Colin
Conversion is required because passing value is string not datetime …
newb
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
newb
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
newb
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
newb
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
newb
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]
newb
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
newb
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
newb
14
Model.find(:all, :conditions => {:time_field => (from…to)})
On Sep 30, 7:02 am, Newb N. [email protected]