Dear All,
When i try to update the date of one of my documents, i get the date shifted 1 hour previous to the correct date.
for example,
if i run the following DQL query
update my_document object set document_date = DATE('02/14/2007') where r_object_id = '###'
then select the date of this document, i get it as follows:
02/13/2007 11:00 PM instead of 02/14/2007
and when i add the time part to the query, as follows:
update my_document object set document_date = DATE('02/14/2007 00:00:00','MM/DD/YYYY hh:mm:ss') where r_object_id = '###'
then select the date of this document, i get it as follows:
02/13/2007 11:00 PM instead of 02/14/2007 00:00 AM
Can anyone explaing the cause of this behavior?
Any inputs will be greatly appreciated.
