DataViewGrid and dates
-
Hi, I have DataGridView in my application connecting to Oracle DB. Oracle table has a date as '03/12/2007' and same is returned to the front end via DataSet. However when this dataset is bound to the grid, the date displayed is '03/11/2007'!!! Similarly all the dates that have two (2) digit days (from 10 to 31) are reduced by a digit! e.g. instead of '03/30/2007' it shows '03/29/2007'. If I do not use any formatting for the .DefaultCellStyle property then the date displayed is '03/11/2007 11:00 PM'. Dates with single digit days i.e. '03/08/2007' stays the same though - with or without formatting. Please note that my SQL statement truncates the date to short date format - TRUNC(pay_date) - already. Any help is really appreciated. Thanks. crzYank
-
Hi, I have DataGridView in my application connecting to Oracle DB. Oracle table has a date as '03/12/2007' and same is returned to the front end via DataSet. However when this dataset is bound to the grid, the date displayed is '03/11/2007'!!! Similarly all the dates that have two (2) digit days (from 10 to 31) are reduced by a digit! e.g. instead of '03/30/2007' it shows '03/29/2007'. If I do not use any formatting for the .DefaultCellStyle property then the date displayed is '03/11/2007 11:00 PM'. Dates with single digit days i.e. '03/08/2007' stays the same though - with or without formatting. Please note that my SQL statement truncates the date to short date format - TRUNC(pay_date) - already. Any help is really appreciated. Thanks. crzYank
You could try and just use text straight from Oracle and use it as string. If you are using a strong typeing thi might not be possible.
Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture) http:\\www.frankkerrigan.com
-
You could try and just use text straight from Oracle and use it as string. If you are using a strong typeing thi might not be possible.
Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture) http:\\www.frankkerrigan.com
-
You could try and just use text straight from Oracle and use it as string. If you are using a strong typeing thi might not be possible.
Grady Booch: I told Google to their face...what you need is some serious adult supervision. (2007 Turing lecture) http:\\www.frankkerrigan.com