CODEWITHSUNDEEP
sqlvisual-studiossisexpression
nia a
nia a

Reputation: 13

SSIS Expression to get julian date from yesterday

Can anyone help me with SSIS Expression I have this query in the expression: Select period, * from table

I want to add a where clause to get period = yesterday

But, period column is in julian date format.

at the end i want the same result like this query Select period, * from table Where getdate() - 1

Thank you

Upvotes: 0

Views: 67

Answers (1)

PCF
PCF

Reputation: 1

you only can use you table date time column to compare with the getdate

Select period,
    dataDate, * 
from table 
    Where dataDate = getdate() - 1

Upvotes: 0

Related Questions