In SQL Server 2000 I have the following query:
CREATE PROCEDURE dbo.xTestDatePart
AS SELECT DATEPART(month, GETDATE()) AS 'Month Number', DATEPART(weekday, GETDATE()) AS Day
Today is Tuesday. When I run this in QA on my server I get the results:
@RETURN_VALUE = 0
and in my Access 2003 adp file running on my local machine connecting to the same db I get the results 7 3
On my server SELECT @@Datefirst returns 1 and in my adp file it returns 7
If anyone can advise where things are going wrong / what settings to examine in order to solve this problem I'd be grateful.