Dear,
i have 2 questions about SQL Statement in Date:
1)
i have 3 fields in a table called "onLeave": Name, DateFrom & DateTo. Now i want to select those people who not in the office at the following date of 28/12/2003 OR 8/1/2004 or BOTH.
2)
In SQL Query Analyzer, how can i change the DATE format (eg. from mm/dd/yyyy to dd/mm/yyyy) in the SELECT Statement?
i have 2 questions about SQL Statement in Date:
1)
i have 3 fields in a table called "onLeave": Name, DateFrom & DateTo. Now i want to select those people who not in the office at the following date of 28/12/2003 OR 8/1/2004 or BOTH.
2)
In SQL Query Analyzer, how can i change the DATE format (eg. from mm/dd/yyyy to dd/mm/yyyy) in the SELECT Statement?
Comment