Can anyone help with the following problem that I'm having:
The following sql statement when executed via sql plus returns '26-OCT-03 17:41:29':
SELECT AC_DATE_LOADED FROM AC_ACCOUNTS WHERE TO_CHAR(AC_DATE_LOADED, 'dd-MON-yy hh24:mi:ss') LIKE '26-OCT-03 17:41:29' AND AC_ACCOUNT_NUMBER = '07950N-01355';
However, when I'm executing the same sql via an FLR, the date being picked up by my code is '26-OCT-03 16:41:29' - ie. being reduced by 1 hour.
The variable I'm using to capture the date is of type java.util.Date and I'm displaying the time element via 'varName.toString()'.
Previous Topic
