Hello!
I have simple problem. Which format should be used for columns with DATETIME type? I clicked on field, then “Now” but in saving i’m getting error: “Invalid date format for property BirthDay”
Hi Michael,
I assume you’re talking about entering a value for DATETIME in console. When you click on a field, console shows date/time picker. Here’s what it looks like.
http://support.backendless.com/public/attachments/bd269865a8c8e556a18d59c8be47bc02.jpg</img>
It sounds like you’re doing something different. Could you describe in more details?
Mark
Hm… I found that this problem I was getting in the RU version backendless.com. In US version values can be saved clearly.
Hello, Michael!
We shall make investigation and fix this issue in the nearest release.
best regards,
Alex Navara
Hello
What it the correct format for “+zone”
Im having the same problem, it was very odd and it took me a while to figure it out.
Im getting a null error code and the error messages is “Unable to adapt response to objetctName”. The catch was, the data was saved. including the date time.
I remove parameters one by one, so I figure the date was the problem.
Couldnt figure it out, why the date was wrong, cause I read the formatting docs and everything seems to be fine. So now just by luck I see there is also a “+zone” which is very hard to see in laptop.
Im sending this “06/20/1986 00:00:00”, what should I append to it for the +zone.
Thanks 
Hi Erick,
Here’s an example of a value which you can enter into console (note that the only way to enter it into console is by copy/paste, you cannot just type it in, there appears to be a bug with entry validation).
10/15/2015 00:00 -0700
Once you enter and save the data (you need to explicitly click the pencil icon on the very right of the record), the data is saved and will be displayed in the GMT-0 timezone. Console displays all dates in GMT-0.
When you save new objects using API, you can use the same format for the time zone.
Regards,
Mark
Hello Mark
Thanks for the quick reply but I try to post that and got the same null error code and error message “Unable do adapt response to Diligence”.
This is the code (deadline is a String Im working on Android):
Backendless.UserService.CurrentUser();
Diligence diligence = new Diligence();
diligence.setName("well user is changing");
diligence.setDescription("but but I keep getting the error");
diligence.setDeadline("10/15/2015 00:00 -0700");
diligence.setPreparation_time(2);
Backendless.Persistence.save(diligence, new AsyncCallback<Diligence>() {
@Override
public void handleResponse(Diligence response) {
Log.d(GlobalApplication.APP_TAG_NAME, "success");
Toast toast = Toast.makeText(getApplicationContext(), "success", Toast.LENGTH_LONG);
toast.show();
}
@Override
public void handleFault(BackendlessFault fault) {
Log.d(GlobalApplication.APP_TAG_NAME, "error code = " + fault.getCode());
Toast toast = Toast.makeText(getApplicationContext(), fault.getMessage(), Toast.LENGTH_LONG);
toast.show();
}
});
Just in case, Im avoiding to use the autogenerated code provided cause I want to actually understand how my app works.What am I doing wrong?
Could you please post the code for the Diligence class?
No problem
package cl.cutiko.diadelpicoapp.BackendLess.Data;
/**
* Created by cutiko on 11-10-2015.
*/
public class Diligence {
private String objectId, name, description, deadline;
private int preparation_time;
public String getObjectId()
{
return objectId;
}
public void setObjectId( String objectId )
{
this.objectId = objectId;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getDescription() {
return description;
}
public void setDescription(String description) {
this.description = description;
}
public String getDeadline() {
return deadline;
}
public void setDeadline(String deadline) {
this.deadline = deadline;
}
public int getPreparation_time() {
return preparation_time;
}
public void setPreparation_time(int preparation_time) {
this.preparation_time = preparation_time;
}
}
I can upload the project to github if you want to, thanks for helping me, this is driving me crazy.
How about changing the “deadline” type to java.utilizing.Date? Also try saving with Backendless.Persience.of( Diligence.class ).save
Regards,
Mark
Greetings
Fixed! The problem is the date datatype, should be a Java.util.Date. Just to be sure I test getting the date and then transforming it to a String, same error. Thanks.
How ever Im not sure if this good or not, cause this means that getting objects by date will be using Java.util.Date, also Im wondering what is going to happen when I implement a date picker (cant remember now how thoose works).
Anyway, problem fixed for now.
Greetings
So Im glad the forum is actually usefull, I decide to make usefull myself. As you can read above the DateTime should be save using a utils.Date datatype. This is kind of troublesome cause a normal datepicker in Android produce integers as the selected date (1 integer variable for year, 1 for month and 1 for day). So Im giving you a code example here so you can easily transform the datepicker selected date into a utils.Date object:
DatePickerDialog.OnDateSetListener createDatePicker = new DatePickerDialog.OnDateSetListener(){
@Override
public void onDateSet(DatePicker view, int year, int monthOfYear, int dayOfMonth) {
Calendar calendar = new GregorianCalendar(year, monthOfYear, dayOfMonth);
Date date = calendar.getTime();
YourObject yourObject = new YourObject();
yourObject.setDateObject(date);
}
};
Here Im doing this inside a onDateSet, which means you will have to find the must suitable way for implementing the datepicker according to your project. Also Im starting the object to be saved inside the onDateSet, but you can do it somewhere else. And setDateObject is the variable which correspond to a datetime in the backendless database.
Hope to be helpfull
Thanks, Erick! I am sure other developers will find it very helpful.
Regards,
Mark
Welcome, Im gonna do my best to help all I can see you arround, hugs.
how to convert java date object to datetime?
How can I store local time in backendless database? Must it be stored in the datetime table column? If yes, how do I store it since most methods in java.util.Date package are deprecated.
I want to store time values like 6:25pm as either 06:25 PM or 18:25 or even 18:25:59 (with the seconds).