String转date sql 数据库日期查询

来源：互联网发布：陕西和泰单片机编辑：程序博客网时间：2024/05/01 02:58

SELECT EESRDD.*

FROM ELEC_EQUIPMENT_STATISTIC_RM_DATA_DAY EESRDD

LEFT JOIN ELEC_MAP_EQUIPMENT_MEASURE_POINT_RM EMEMPR

ON EESRDD.RM_ID = EMEMPR.EQU_RM_ID

LEFT JOIN BASE_MEASURE_POINT_REMOTE_METERING BMPRM

ON EMEMPR.MP_RM_ID = BMPRM.RM_ID

LEFT JOIN BASE_MEASURE_POINT BMP

ON BMPRM.MEASURE_POINT_ID = BMP.MEASURE_POINT_ID

WHERE BMP.MEASURE_POINT_NO = 'HD_MP_0022'

AND BMPRM.RM_NAME = '当前A相电流'

AND EESRDD.RM_NAME = '当前A相电流'

AND EESRDD.DATA_START_TIME = STR_TO_DATE('2015-08-28 00:00:00', '%Y-%M-%D %H:%I:%S')

SELECT eesrdd.*

FROM elec_equipment_statistic_rm_data_day eesrdd

LEFT JOIN ELEC_MAP_EQUIPMENT_MEASURE_POINT_RM EMEMPR

ON eesrdd.RM_ID = EMEMPR.EQU_RM_ID

LEFT JOIN BASE_MEASURE_POINT_REMOTE_METERING BMPRM

ON EMEMPR.MP_RM_ID = BMPRM.RM_ID

LEFT JOIN BASE_MEASURE_POINT BMP

ON BMPRM.MEASURE_POINT_ID = BMP.MEASURE_POINT_ID

WHERE BMP.MEASURE_POINT_NO = 'HD_MP_0022'

AND BMPRM.RM_NAME = '当前A相电流'

AND eesrdd.RM_NAME = '当前A相电流'

AND eesrdd.DATA_START_TIME >= '2015-08-28 00:00:00' AND eesrdd.DATA_START_TIME < '2015-08-29 00:00:00'

mysql：

STR_TO_DATE('2015-08-28 00:00:00', '%Y-%M-%D %H:%I:%S')

sql server：

to_date('2015-08-28 00:00:00','yyyy-MM-dd hh:mm:ss')

0 0