unigui中绑定unidatetimepicker到mysql中unixtime类型字段

1、设置fdconnection中parameter的字符集。

Server=localhost
Database=test
User_Name=root
Password=root
DriverID=MySQL
CharacterSet=utf8

 

2、放置fdquery并设定query中的sql语句。FROM_UNIXTIME(evs_endtime) as evs_endtime

select evs_id,evs_sn,evs_name,evs_tel,evs_customname,evs_customtel,FROM_UNIXTIME(evs_starttime) as evs_starttime,FROM_UNIXTIME(evs_endtime) as evs_endtime,FROM_UNIXTIME(evs_otstime) as evs_otstime,FROM_UNIXTIME(evs_rnstime) as evs_rnstime ,evs_province,evs_city,evs_area,evs_address,evs_remarks from v1_events

3、点击add all field 按钮。

4、放置unidatetimepicker组件并设置datasource和datafield属性。

结果。