如何将字符串datetime保存到数据库中的datetime字段?
问题描述:
即时使用rails 3应用程序。我不能保存我的日期时间值从我的日期时间选择器到我的数据库在SQL Server 2005.我不断收到无效的日期。有什么建议么?如何将字符串datetime保存到数据库中的datetime字段?
我有这个在我的模型:
scope :available, lambda {
|checkin, checkout| {
:select => 'amenities.*',
:order => 'id',
:conditions => ["
amenities.id NOT IN
(
SELECT aa.id from amenities aa, amenity_list al WHERE
aa.id = al.amenities_id AND
(
(? BETWEEN al.checkin AND al.checkout) OR
(? BETWEEN al.checkin AND al.checkout)
)
)",
checkin, checkout
]
}
}
这里是我的控制器:
def step2
@cart = current_cart
checkin = params[:checkin]
checkout = params[:checkout]
@amenities = Amenity.available(checkin, checkout)
session[:checkin] = checkin
session[:checkout] = checkout
end
的application.js
$(function() {
var dates = $("#checkin, #checkout").datetimepicker({
dateFormat: 'mm/dd/yyyy hh:MM:ss TT',
buttonImageOnly: true,
buttonImage: 'images/icons/cal.png',
showOn: 'button',
showAnim: 'blind',
defaultDate: "+1w",
changeMonth: false,
numberOfMonths: 2,
minDate: new Date(),
onSelect: function(selectedDate) {
var option = this.id == "checkin" ? "minDate" : "maxDate",
instance = $(this).data("datetimepicker"),
date = $.datetimepicker.parseDate(
instance.settings.dateFormat ||
$.datetimepicker._defaults.dateFormat,
selectedDate, instance.settings);
dates.not(this).datetimepicker("option", option, date);
}
});
});
答
您是否尝试过Date.parse(签)?
不,还没有?怎么样? :( – Crisgine 2011-05-20 16:43:15
您是否使用jquery日期选择器? – Arun 2011-05-20 16:56:14
是的,我使用它。 – Crisgine 2011-05-20 17:07:19