Upload from db2 data into SQL Server 2014

[donalexander]

Hello,

I am running the latest version of iSeries (AS/400) I want to do a nightly upload into SQL Server table (2014). My problem is the invDate field is 6 digits (year/month/day):
for the date 160620 is really 06/20/16. How do I get to read only today's date? Below is my code, but I don't know how to code to get for today's date.

Select orderID, invDate, OrderAmt
from OrderDetail
Where invDate = Current(Date)


Any help will be appreciate. Thank you.

 

[SkipVought]

HI,

Current(Date) is a number: have no idea how that's represented in BD2 but it's probably the number of DAYS or SECONDS, for instance, since some reference date/time. So the date 2016/06/20 is represented as some number like 42541, which is how that date would be represented in a Microsoft application.

160620 is a string of numeric characters.

Do you see the difference?

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[donalexander]

yeah, Thanks!