Bill Crawley
November 27th, 2003, 07:41 AM
Hi All,
in SQLServer 2000 as part of a Select statement I have:
(CONVERT(char(11), dbo.Submission.GatewayTimestamp, 103) > '13/05/2001')
in my Where clause.
The GatewayTimestamp column is of type datetime.
Why do I have returned records where the date is '24/04/2001' as well as Records > than my date specified?
in SQLServer 2000 as part of a Select statement I have:
(CONVERT(char(11), dbo.Submission.GatewayTimestamp, 103) > '13/05/2001')
in my Where clause.
The GatewayTimestamp column is of type datetime.
Why do I have returned records where the date is '24/04/2001' as well as Records > than my date specified?