jQuery datepicker设置为null [英] jQuery datepicker set to null

问题描述

我在表中将日期设置为Null时遇到问题.我有日期选择器，默认情况下为空白(保存时，它以0000-00-00的形式返回到DB，但我想将其设置为Null.在列选项中，我将默认设置为Null.

I have a problem with setting a date to Null in my table. I have datepicker that is by default blank (and when I save, it return to DB as 0000-00-00 but I want to set as Null. In column option I set default to Null.

这是我的HTML:

<div class='col-sm-2'>
Datum kontakta
<div class="form-group">
<div class='input-group date' id='datum_kontakta_picker'>
<input name="datum_kontakta" type='text' class="form-control" value="<?php echo $values['datum_kontakta']?>" />
<span class="input-group-addon">
<span class="glyphicon glyphicon-calendar"></span>
</span>
</div>
</div>
</div>

和用于日期选择器的脚本:

and script that for datepicker:

<script>
    $('#datum_kontakta_picker').datetimepicker({
        format: 'YYYY/MM/DD',   
    }, function(start, end, label) {
        console.log(start.toISOString(), end.toISOString(), label);
      }
    );
</script>

当datepicker为空时如何将Null保存到表中?

How can I save Null to the table when datepicker is empty?

我尝试设置defaultDate: null，但没有帮助.

I try to set defaultDate: null but did not help.

推荐答案

建议您在数据库的表中设置最小DateTime值，而不是将日期设置为null.

It is recommended that you should set minimum DateTime value in the table of your DataBase instead of null for dates.

如果要以字符串格式存储，则可以使用:

Whereas if you want to store in string format, then you can use :

$('#datum_kontakta_picker').val() ? $('#datum_kontakta_picker').val() : null;

这篇关于jQuery datepicker设置为null的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！