when I use system variable @date in expression
Oconv(@DATE,"DDZ")=13
THE condition can be satisfied.
today is 2010-07-13
but when I use sequence job parameter I_DATE
Oconv(I_DATE,"DDZ")=13
here the value of I_DATE is 2010-07-13
but the condition can not be satisfied.
Is there any differences?
expression in trigger
Moderators: chulett, rschirm, roy
-
priyadarshikunal
- Premium Member
- Posts: 1735
- Joined: Thu Mar 01, 2007 5:44 am
- Location: Troy, MI
How the condition can be satisfied when DDZ returns 13/Bst
@date is internal representation of the date which will return 15535 today and hence the answer is 13/Bst, "DD" will return 13.
In sequence job instead of using oconv() directly on I_DATE, use OConv(IConv(I_DATE, "D-YMD"), "DD") which will return 13 to match the condition.
@date is internal representation of the date which will return 15535 today and hence the answer is 13/Bst, "DD" will return 13.
In sequence job instead of using oconv() directly on I_DATE, use OConv(IConv(I_DATE, "D-YMD"), "DD") which will return 13 to match the condition.
Priyadarshi Kunal
Genius may have its limitations, but stupidity is not thus handicapped.
Genius may have its limitations, but stupidity is not thus handicapped.