Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I think there is an issue with this formula in my where clause. can anyone see an issue with this??
APPT_DATETIME >= CONVERT(DATETIME, '2019-01-01 00:00:00',102)
(the format of the field is YYYY-MM-DD 00:00:00.000000)
thanks for you help. I realised i was connecting to an oracle database so have to use the TO_DATE function
I think you are using the wrong Style in convert function. Try this:
CONVERT(DATETIME, '2019-01-01 00:00:00',120)
thanks for you help. I realised i was connecting to an oracle database so have to use the TO_DATE function