formatting dates for a sql server pass through

[DanD999]

I pulled this date from sql server and tried putting single quotes around it but that didn't work. I saw somewhere that %bquote was used so I tried that too. Any suggestions appreciated.

proc sql inobs=7;

connect to SQLSVR (user=&user. Password=&pass. dsn=&db.);

create table members as

select * from connection to SQLSVR

(

select *

from jkl.table1

where entered_dt >= '22OCT2018:07:00:00.0000000'

);

disconnect from sqlsvr;

quit;

Thanks

[RichardDeVen]

Try

YYYY-MM-DD

So

where entered_dt >= '2018-11-22'

[DanD999]

---

@RichardDeVen wrote:

Try

YYYY-MM-DD

So

where entered_dt >= '2018-11-22'

---

The query runs successfully but it doesn't give the correct answer. How do I find rows where the time is after 7AM on that date?

Thanks

[DanD999]

---

@RichardDeVen wrote:

Try

YYYY-MM-DD

So

where entered_dt >= '2018-11-22'

---

If I change the datetime to '2020-10-22:07:00:00.0000000' I get this error:

ERROR: CLI open cursor error: [SAS][ODBC SQL Server Wire Protocol driver][Microsoft SQL Server]Conversion failed when converting

date and/or time from character string.

[SASKiwi]

A Google search will provide the answer:

 '2020-10-22 07:00:00'

[DanD999 · Accepted solution]

---

@RichardDeVen wrote:

Try

YYYY-MM-DD

So

where entered_dt >= '2018-11-22'

---

This works '2020-11-22 07:00:00'. Thanks for getting me on the right track.

[SASKiwi]

@DanD999  - Please mark the post as answered then.