180 sqlcode
-
Arun Rajput
- New Member
- Posts: 9
- Joined: Tue Jan 20, 2015 8:40 am
180 sqlcode
I am getting 180 sqlcode while selecting record from table where date is current date ... didn't find any issue with date format...what could be the reason...any suggestions
-
Robert Sample
- Global Moderator
- Posts: 1895
- Joined: Fri Jun 28, 2013 1:22 am
- Location: Dubuque Iowa
Re: 180 sqlcode
The message seems pretty clear -- either the length of the date field you are using is wrong, or the format doesn't match what DB2 is expecting (YYYY-DD-MM instead of YYYY-MM-DD for example). Since you didn't provide us with anything else, that's about all we can say. If you had provided the query or at least the field in question, we might have been able to do more.
Create an account or sign in to join the discussion
You need to be a member in order to post a reply
Create an account
Not a member? register to join our community
Members can start their own topics & subscribe to topics
It’s free and only takes a minute