Posted by fjleon on 10/02/20 11:48

Do you know how to use that constructed date in a WHERE? dateadd.....
as mydate where '20060501' <=p for example doesn't work

The weird thing is that in sql analizer it shows mydate as the name of
the column but if i use it in the where it fails

• Next in forum: Re: SQL 2000 -> SQL 2005 conversion sql authentication problem
• Prev in forum: Re: Creating dates from table columns
• Thread view: Re: Creating dates from table columns

[Reply to this message]