The formate of date is error

[freefree]

My version is 1.4.7
I set the formate of date is 'yyyy-MM-dd hh:ss:mm' because oracle's date include date and time ,but the date is always 12:00:00 in data list. How to do?
2009-09-07 12:00:00
2009-09-18 12:00:00
2009-09-18 12:00:00
2009-09-18 12:00:00
2009-09-18 12:00:00
2009-09-18 12:00:00
2009-09-19 12:00:00
2009-09-19 12:00:00

[Support]

Hi,

Oracle has three different data types: DATE, TIME and TIMESTAMP.
Oracle DATE doesn't contain time, if you need time value along with date then you have to use TIMESTAMP column type.

I hope I understood the problem correctly