S
smartsysISV
Guest
I have a date-field with this option: If I establish a record the default date is not my local date . I think it is the servers date. If I establish a record before 07:00 am I got the wrong date (The date before), becuase of the differencies in the timezones. Both my personal and company's setting is: Is there any solution on this problem? When I save this record, and test it with a select, I see the db is saved with no timezone: ex: If I create a record dynamically and save the current date (rbv_api.getCurrentDate()) to the same field, this date is saved with timezone. ex: Even if this date is only a DATE-field it is saving the time of date too. I then get a problem if i use to select on a specific date, becuase "where date='2015.06.11' will not return any records. Is this as it shouuld be, or is it an error? Does anyone have good suggestions on how the dates should be treated?
Continue reading...
Continue reading...