SQLServerCentral » Latest topics
How to code to find date and time
I need to run daily script to create a report.
How to code to find out data like below
select * from order where orderDateTime between ('getdate()-2 10:00 AM') and ('getdate()-1 5:00 PM')?
For example, today date in 2017-11-21
I need a rep
How to code to find out data like below
select * from order where orderDateTime between ('getdate()-2 10:00 AM') and ('getdate()-1 5:00 PM')?
For example, today date in 2017-11-21
I need a rep
No comments:
Post a Comment