on 09-18-2006 8:50 AM
Hi,
I have requirement where in the query I need to select the Document delivery date = today's date or system date.
Can any once please let me know how to write the query?
Murali
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Select * from ORDR where docduedate=convert(char(8), getdate(), 112)
Hi Murali,
Any luck with the query?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.