开发者

jUI TimePicker and MySQL DATETIME column

开发者 https://www.devze.com 2023-01-07 17:35 出处:网络
I\'m using the Martin Milesich TimePicker, which is basically the jUI datepicker with hour/minute sliders attached to it.

I'm using the Martin Milesich TimePicker, which is basically the jUI datepicker with hour/minute sliders attached to it.

I have a couple of queries regarding this:

1) I'm storing the data in a database field of type DATETIME - as you're probably aware the default format for this field is 2010-07-19 14:00:00. In my form field however I am displaying the date/time in a more friendly way, i.e. 19/07/2010 14:00 (uk format). So how can I convert my friendly format into the MySQL format after posting the form?

2) Optionally, is it possible for the time portion to be inputted in to its own field? I looked in the timepi开发者_Go百科cker.js file and noticed a setting 'altTimeField' - which it says is a 'Selector for an alternate field to store time into' but so far I have not been able to get this to work.

Thanks.


$mydatetime=date('Y-m-d H:i:s', strtotime($mydatetime));
0

精彩评论

暂无评论...
验证码 换一张
取 消