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

  从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：修改系统时间格式

从左到右转