import from odbc where date = getdate() dont work

[sixtoedsloth]

HI,

Please can you tell me how to do this :-

DTS package
input : connx ODBC for powerflex
output : sql server 2000

source sql statement:-

select * from scanbox where scanned_date = convert(char(10),getdate(),10)

this wont work! how do i restrict the select based on
the date field?

Regards,


Russ

 

[JayKusch]

Is scanned_date a DateTime data type?

If so, then try ...

select *
from scanbox
where convert(char(10),scanned_date,10) =
convert(char(10),getdate(),10)


Thanks

J. Kusch

 

[johnherman]

The format type (10) you chose for the convert does not have ten characters, only 8 (no centuries). It's format is mm-dd-yy

Hope this helps.

Sometimes the grass is greener on the other side because there is more manure there - original.

 

[JayKusch]

Johnherman is correct.

As you will see in my example above though, I have taken that into account and formatted the scanned_date to use a "Style" of 10 so that the comparisons are based on the same formatting rule.

Thanks

J. Kusch