Storing/Fetching Date&time from /to Bubble app

Hello experts,

I've been learning Xano for my backend alternative to Bubble's built-in database for a while. I am getting better though slow yet. I am kind of a learn-build type of a person, so I am in the process of building an app while I am still learning Xano. It's a kind of a booking app.

Anyways, today I've spent whole day struggling with date/time stuff.

In Xano, this is what I have in the booking table. 2 date-related fields are set to timestamp.

Then, I connected Xano to my Bubble app via API connector. The POST and GET settings are as below.

I also set the fields (date_booked and date_time) both in date (UNIX).

I tested to find the date data are stored fine.

But, when I fetch the date data back to the Bubble app, it looks like this.

57052/08/14 1:00 pm for Jan 30, 2025 9:19 PM and so on.

  1. Could any Xano senior confirm if my settings are okay or I need to fix something?

  2. How can I fix this fetching problem at Bubble?

Thank you very much.

2 replies