Select query unable to retrieve result

Asked Jan 06 '22 at 06:51

Active Jan 06 '22 at 20:14

Viewed 37 times

I have a query which on executing, gives the below error.

Conversion failed when converting date and/or time from character string.

The Query is

SELECT EMPLOYEE_NUMBER 
FROM PER_PERSON 
WHERE IS_ACTIVE = 'Y' 
AND '31-01-2022 00:00:00' 
BETWEEN EFF_START_DATE and ISNULL(EFF_END_DATE, '31-01-2022 00:00:00')  
AND ANALYST = (SELECT USERNAME FROM SEC_USER WHERE USER_ID = '100061')

Attaching screenshot for reference.

TIA

edited Jan 06 '22 at 20:14

Charlieface

52,284
6
19
43

asked Jan 06 '22 at 06:51

ispostback

6

Try to use a more "standard" (*sane*?) date format like `'2022-01-31 00:00:00'` for your date literal or explicitly `convert()` the string with the right format designation. – sticky bit Jan 06 '22 at 06:59
@stickybit, thanks for the insight – ispostback Jan 06 '22 at 07:00

Select query unable to retrieve result

0 Answers0