date formula in where clause

[Fig1]

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)

[fosuzuki]

I think you are using the wrong Style in convert function. Try this:

CONVERT(DATETIME, '2019-01-01 00:00:00',120)

[Fig1 · Accepted solution]

thanks for you help.  I realised i was connecting to an oracle database so have to use the TO_DATE function