I transform data from a DB2 table to a SQL tabel. The date format in the DB2
is in decimal 10 chr (and we need in taht format since a report generator
uses that format). But I want to replicate data that is Today-10 days so my
string is:

select * from mvxbdtm.meslog where meslog.locono=1 and LORGDT>20050926

so I need manually change the date every day.

Does someone know how to change from @date to a decimal but this does not
work:

select * from mvxbdtm.meslog where meslog.locono=1 and LORGDT>@date-10

select * from mvxbdtm.meslog where meslog.locono=1 and
LORGDT>CONVERT(CHAR(8), GETDATE() -10, 112)

Btw, your code return the data newer than the last 10 days, not older.

--
Jacco Schalkwijk
SQL Server MVP


"Jarkko" <Jarkko (AT) discussions (DOT) microsoft.com> wrote