By: Martin Phee - mphee
Formating a date with pattern using oracle
2002-11-04 06:59
I have two Oracle date fields. Open_date, close_date. If I use a pattern of "MM/dd/yyyy" it works fine, but when I add HH:mm:ss I'm not getting the the time.
I worked around by doing a to_char on the field and putting it into the format I want.
I tried to do not pattern and all I got was '2002-11-02'.
pattern="MM/dd/yyyy HH:mm:ss" isn't working.
Formating a date with pattern using oracle
2002-11-04 06:59
I have two Oracle date fields. Open_date, close_date. If I use a pattern of "MM/dd/yyyy" it works fine, but when I add HH:mm:ss I'm not getting the the time.
I worked around by doing a to_char on the field and putting it into the format I want.
I tried to do not pattern and all I got was '2002-11-02'.
pattern="MM/dd/yyyy HH:mm:ss" isn't working.
0 Answers:
No answers yet
