The formate of date is error

Note: please leave bug reports and feature requests on

The formate of date is error

Postby freefree » Sun Jan 15, 2012 7:47 am

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
freefree
 
Posts: 5
Joined: Sun Jan 15, 2012 7:43 am

Re: The formate of date is error

Postby Support » Tue Jan 17, 2012 2:20 pm

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 :)
Support
 
Posts: 49
Joined: Thu Mar 17, 2011 10:11 am


Return to Support



Who is online

Users browsing this forum: No registered users and 12 guests