BCB 处理机器时间设置（h or HH）不同的bug

来源：互联网发布：数据挖掘就业前景编辑：程序博客网时间：2024/04/20 03:29

从DateTimePicker获取的时间戳包含了“上午，下午”等字符，导致查询数据库失败

原代码为：

        String sStartTimeDate = DateTimePickerStartDate->DateTime.DateString();        String sStartTimeHour = DateTimePickerStartTime->DateTime.TimeString();        String sEndTimeDate   = DateTimePickerEndDate->DateTime.DateString();        String sEndTimeHour   = DateTimePickerEndTime->DateTime.TimeString();        String sBeginTimeDateHour = sStartTimeDate + " " + sStartTimeHour;        String sEndTimeDateHour   = sEndTimeDate   + " " + sEndTimeHour;

解决方案1：修改获取方式

        String sStartTimeDate = DateTimePickerStartDate->Date.FormatString("yyyy-MM-dd");        String sStartTimeHour = DateTimePickerStartTime->Time.FormatString("HH:mm:ss");        String sEndTimeDate   = DateTimePickerEndDate->Date.FormatString("yyyy-MM-dd");        String sEndTimeHour   = DateTimePickerEndTime->Time.FormatString("HH:mm:ss");        String sBeginTimeDateHour = sStartTimeDate + " " + sStartTimeHour;        String sEndTimeDateHour   = sEndTimeDate   + " " + sEndTimeHour;

解决方案2：修改系统时间格式

从左到右转