Date format
Moderators: chulett, rschirm, roy
Date format
I have a Date column in the source table . I am doing a look up with this datecolumn in my source table with the Date column in another table. Both are in same format. As of know I have no warnings or errors. will I get any warnings in future production runs?.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Date is a data type, and has a specific internal format. They will remain comparable in production.
It is only when folks start converting their dates to incompatible string forms that comparisons fail.
It is only when folks start converting their dates to incompatible string forms that comparisons fail.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Ah... thanks for a real answer. All that popped into my head when I saw that question was a Magic 8 Ball.
Will I get any warnings in future production runs?
<shake shake>
Outlook good
Will I get any warnings in future production runs?
<shake shake>
Outlook good
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers