Connecting time to a table

Ask the community
,
1

I made a table connected to my database, but I can’t connect data with the type “Time”. Can anyone help ?

2

Hi,

What you need is to create a field of type “date” in your database, and using the wix code you can extract the time and display it in the table.

//extract time function
function dateToTime(date) {
return date.getHours() + “:” + pad(date.getMinutes()) + “:” + pad(date.getSeconds());
}
//you can put a zero on time ex: 1=01
function pad(t) {
let st = “” + t;
while (st.length < 2)
st = “0” + st;
return st;
}
// lets test it
console.log(dateToTime( new Date()));
$w.onReady( function () {
$w(“#MyRepeater”).onClick((event) => {
$item(“#myTimeText”).text = dateToTime(itemData.dateField);
// more fields
});
});