DATE format ("DatePattern") giving wrong output


TOS 3.2.1

I got resultset from database containing list of dates pulled in format "MM-dd-yyyy" which are then passed to InformixInput control as arguments of select statement. Thing is ... ones passed InformixInput will give me error.

java.sql.SQLException: Invalid year in date

so ... instead of sending parameters to InformixInput I sent them to myself in email body to see how date looks like and it striked me that date came back as

Tue Jan 05 00:00:00 PST 2010

... and that's definitely not what I want.


So my question is ... why date didn't come out in "MM-dd-yyyy" format as expected and how to fix it?







mishomor's picture
Joined: Jan 6 2010 - 4:40pm
Last seen: 5 years 3 months ago

0 Answers:

No answers yet